Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: can't create table from package
On Dec 8, 8:22 am, andi..._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
Why would you want to do this in the first place?
this is just dangerous practice. Don't do it. Ed Received on Mon Dec 10 2007 - 11:34:42 CST