Re: Non DBA UPDATE STATISTICS

Posted in 1998

Tom Grenier — Thu, 10 Sep 1998 19:48:21 -0400 — source: Informix-list mailing list archive (1991-1998)

Wouldn't the easiest thing to do is create a dba procedure and grant execute to y? Tom sanjeev sagar wrote: > Informix IDS 7.30 > O/S : Solaris 2.5.1 > > There are two user id, user x and user y. User x owns > the database and tables. There is a requirement that > user y should run the UPDATE STATISTICS. > > I did check that for running the update statistics, > it has to have DBA priviledge, even for giving SET > SESSION AUTHORIZATION. > > B'coz of security reason i can not grant DBA to User > y. And i have to run UPDATE STATISTICS under user y > id. Is it possible?? > > I would highly appreciate any help for the same. > > Sanjeev > > _________________________________________________________ > DO YOU YAHOO!? > Get your free @yahoo.com address at http://mail.yahoo.com