Re: Non DBA UPDATE STATISTICS

Posted in 1998

Art S. Kagel — Tue, 08 Sep 1998 17:06:56 -0400 — source: Informix-list mailing list archive (1991-1998)

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. Create a 4GL or ESQL/C program that runs suid to a DBA account and have that app execute the UPDATE STATISTICS commands. You can get my dostats.ec from the IIUG Software Repository, in the submission named utils2_ak, and make it an suid program. Art S. Kagel