Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sys.DBMS_DDL.CREATE_WRAPPED what other priviledges are needed?

sys.DBMS_DDL.CREATE_WRAPPED what other priviledges are needed?

From: <nkunkov_at_escholar.com>
Date: 5 Jul 2006 08:07:01 -0700
Message-ID: <1152112021.267506.228690@j8g2000cwa.googlegroups.com> 





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
Received on Wed Jul 05 2006 - 10:07:01 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US