running process as another user

Hi Guys, Listen to this one. I've a billing system comprised of many programs. The end result of one program leads to the data needed to do the following. Whenever I'm finished with a program, I'd like for the statistics to be updated 'high' for the table in which data was inserted. However, the user running the program does not have the necessary privileges. How can I run the update statistics high as user who doesn't have privileges. Any help will be greatly appreciated. Austin

create a stored procedure to run the update stat. grant execute to the other user. -- ---------------------------------------------------------Steven Hauser email: hause011@tc.umn.edu URL: http://www.tc.umn.edu/~hause011 ---------------------------------------------------------

Also, make sure when you create the procedure you create it as DBA. That way, the procedure will execute with DBA level permissions. Otherwise, it will execute with the normal user's permissions. --Steven Steven Hauser wrote: > create a stored procedure to run the update stat. > grant execute to the other user. > -- > ---------------------------------------------------------> Steven Hauser > email: hause011@tc.umn.edu URL: http://www.tc.umn.edu/~hause011 > --------------------------------------------------------- -- ----------------------------------------------------- Steven Mastandrea stevem@cstech.com Systems Designer 847.397.7300 CSTech, Inc. Schaumburg, IL

Forgive the ignorance, but isn't there a 'create dba procedure', or some such? I seem to remember reading about it, but I can't find it right now. -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.