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

Home -> Community -> Usenet -> c.d.o.misc -> Re: can't create table from package

Re: can't create table from package

From: <sybrandb_at_hccnet.nl>
Date: Mon, 10 Dec 2007 07:17:01 +0100
Message-ID: <3empl3dj01s0i8ie736mgnfilvhqfdrd7v@4ax.com>


On Sat, 8 Dec 2007 05:22:47 -0800 (PST), andized_at_gmx.net wrote:

>Hello,
>
>i am having trouble creating tables from a package using oracle 10g.
>i am logged in as user 'testuser' and am working in the users schema
>'testuser' where the user is allowed to perform CREATE TABLE
>statements, also the EXECUTE right is granted. but when i execute a
>package with a statement like EXECUTE IMMEDIATE 'CREATE TABLE ...'; i
>receive a ORA-01031 (insufficient privileges). if i execute the create
>statement from an editor window the table will be successfully created
>since i am granted CREATE TABLE.
>
>it looks like the grants of the users session are changed when i am
>inside a package, but i am wondering why this should make any sense
>and how i can get the GRANTS to work inside a package too.
>
>any ideas? help would be highly appreciated!
>AndiZed

Creating tables through packages is just plain evil.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Mon Dec 10 2007 - 00:17:01 CST

Original text of this message

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