In article <c8hvrf$6mc$1_at_unbe.sarenet.es>, Jon says...
> 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"
>
You'll probably find that the procedure is effectively trying to create
the table under the user that 'owns' the procedure, rather than that
which is executing it.
--
jeremy
Received on Thu May 20 2004 - 05:19:47 CDT
