Re: sys.DBMS_DDL.CREATE_WRAPPED what other priviledges are needed?

nkunkov_at_escholar.com wrote:
> Hi,
> 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?
> Appreciate your help.
> Thanks
> NK

Your might think of adding to your stored procedure the AUTHID CURRENT_USER directive. You should read this to understand how this can help:

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/08_subs.htm#18575

David Fitzjarrell Received on Wed Jul 05 2006 - 14:34:50 CDT