You need to read on up on permissions. privileges that you get thru a role does not work for stored objects, like proces/pkgs.
joe Csillag Zsolt wrote: > Hi, > > The following code work as you can see below, but if I put this > code in a package ( a procedure in a package) then I got > ORA-01031 insufficient privileges error. > > This is absurd for me because it's the same user (an administrator) that > owns the package, tablespace, table and everything. > From a pl/sql block it works perfectly with the same user. > > > > *Declare > * Command *VarChar2*(*1000*) ; > *Begin > > > * Command := *'create table PROBA1 > ( > PROBA1_1 NUMBER, > PROBA1_2 VARCHAR2(50) > ) > tablespace XXX > pctfree 10 > pctused 40 > initrans 1 > maxtrans 255 > storage > ( > initial 64K > minextents 1 > maxextents unlimited > )'* ; > > > *Execute* *Immediate* Command ; > > > *end* ; -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
