Re: can't create table from package

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