can't create table from package

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 Received on Sat Dec 08 2007 - 07:22:47 CST