I'm missing something obvious

From: <garysadler_at_my-deja.com>
Date: Thu, 26 Aug 1999 22:47:45 GMT
Message-ID: <7q4g6g$dhg$1@nnrp1.deja.com>

I am trying to execute dbms_shared_pool from within a stored procedure owned by SYS, and getting privilege errors, even if SYS is the user executing the procedure. Dbms_shared_pool is owned by SYS, as is dbms_utility. It's got something to do with roles because SYS can actually execute dbms_shared_pool from sqlplus, unless I issue SET ROLE NONE, then try it. Why would SYS need a role to execute a package that it owns?

Here's the exact message I get when running sqlplus after SET ROLE NONE:

begin dbms_shared_pool.keep('owner.packagename'); 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 43
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 51
ORA-06512: at line 1

Oracle 8.1.5
Solaris 2.6

Gary Sadler
Polygon Network
gary_at_polygon.net

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 26 1999 - 17:47:45 CDT