Re: Non DBA UPDATE STATISTICS

Posted in 1998

WF Software — 8 Sep 1998 22:33:55 GMT — source: Informix-list mailing list archive (1991-1998)

In article <6t450t$bjq$1@news.xmission.com>, sanjeevsagar@rocketmail.com (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 > > Write a setuid wrapper to pretend to be the user you require Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #