Re: The code doesn't work in the package

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: teci_at_the-testas.net

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: ListGuru_at_fatcity.com (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).