Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: sys.DBMS_DDL.CREATE_WRAPPED what other priviledges are needed?
fitzjarrell_at_cox.net wrote:
> 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
Thanks for your help.
NK
Received on Thu Jul 06 2006 - 07:59:56 CDT
![]() |
![]() |