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.
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Mar 03 2004 - 23:00:25 CST
