Hi, Thank you for your help. Now it works.
At 11:00 2001.12.16. -0800, you wrote: >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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).