** ORA-1031 on execute of DBMS_SHARED_POOL in a procedure
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 3 Mar 2004 21:03:38 -0800 (PST)
Hi,
Posting again : I am getting the following error when trying to run a
procedure that
calls DBMS_SHARED_POOL. DBMS_UTILITY is not called from the procedure.
Yes, I already have execute on DBMS_SHARED_POOL granted directly to the
user (not thru a role). It would not create the proc before that. I
tried granting with grant option and also granted execute on DBMS_UTILITY
directly to the user. I am executing the procedure as the user who owns
it. If I execute the statements in procedure at SQL prompt it works
fine. Can some one help. Thanks
SQL> execute proc_init
BEGIN proc_init; END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_UTILITY", line 68
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
ORA-06512: at "P9K.PROC_INIT", line 1
ORA-06512: at line 1
---------------------------------
Do you Yahoo!?
Yahoo! Search - Find what you?re looking for faster.
Other related posts:
- » ** ORA-1031 on execute of DBMS_SHARED_POOL in a procedure
