Sorry, this is perfectly normal and makes sense when you understand the security implications.
May I suggest the Concepts manual at tahiti.oracle.com? Also, if you go take a look at www.orafaq.com you will find an answer to this question, and being the lazy DBA that I am, it will save me some typing. Jared On Sunday 16 December 2001 09:35, 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 ; ---------------------------------------- Content-Type: text/html; charset="us-ascii"; name="Attachment: 1" Content-Transfer-Encoding: 7bit Content-Description: ---------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).