Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sys.DBMS_DDL.CREATE_WRAPPED what other priviledges are needed?
On 5 Jul 2006 08:29:30 -0700, sybrandb_at_yahoo.com wrote:
>nkunkov_at_escholar.com wrote:
>> I'm trying to use sys.DBMS_DDL.CREATE_WRAPPED in my own stored
>> procedure. I logged in as SYS and gave myself priviledges to execute
>> this package. But Oracle 10g still gives me this error:
>>
>> ORA-01031: insufficient privileges
>> ORA-06512: at "SYS.DBMS_DDL", line 643
>>
>> Is there some other package that I should grant execute permissions to?
>> What else should I do to be able to execute the above?
>
>Evidently, one would need *direct* privilege (ie not through a role) to
>execute the actual commands submitted, as roles are ignored when
>executing stored procedures.
No, that's for definer rights procedures. DBMS_DDL.CREATE_WRAPPED is invoker rights, as listed in the documentation. Privileges from roles are not ignored in invoker rights procedures.
-- Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis toolReceived on Wed Jul 05 2006 - 13:34:24 CDT