Re: PL/SQL privileges

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 20 May 2004 19:09:49 GMT
Message-ID: <1o7rc.29250$gr.2702773@attbi_s52>

"Jon" <aaa_at_bbb.ccc> wrote in message news:c8hvrf$6mc$1_at_unbe.sarenet.es...
> Hi,
>
> A user has "create any table" privileges and the same user has a procedure
> with
>
> "execute immedate 'create table ...'"
>
> when the user tries to run the procedure, it returns the following error
>
> "ORA-01031: insufficient privileges"
>
> thanks
>
>

Why are you doing this? It is in general a very bad idea. My guess is you came from MS SQL server or Sybase where you have to do this all the time. If you really really need a temporary table then look up global temporary tables.
Jim Received on Thu May 20 2004 - 14:09:49 CDT