Re: can't create table from package

it was part of a package i had to port. the original author said dropping & creating these tables was faster than performing a truncate. i meanwhile replaced the CREATEs with ALTER statements. btw, the CREATEs were not the most evil part in the original package ;)

AndiZed

On 10 Dez., 18:34, Ed Prochak <edproc..._at_gmail.com> wrote:
> 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 Wed Dec 12 2007 - 09:22:52 CST