Non DBA UPDATE STATISTICS

Posted in 1998

sanjeev sagar — Tue, 8 Sep 1998 13:08:57 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

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