running process as another user
Austin Castro asked how to run update statistics high after a billing program for a user lacking the privileges. Steven Hauser suggested a stored procedure running the update statistics, with execute granted to that user. Steven Mastandrea added it must be created as DBA so it runs with DBA permissions. Another poster recalled a 'create dba procedure' form. No confirmation of outcome.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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.