Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 'insufficient privileges' from DBMS_SQL.PARSE call
Thomas Kyte wrote:
>
> roles are never enabled during the execution of a procedure.
>
> Try this:
>
> SQL> set role none;
> SQL> "statement you want to test to see if it'll work in a procedure"
>
> If you can do it in plus with no roles you can do it in a procedure. If you
> can't, you must have the privelege from a role and hence won't be able
> to do it in a procedure.
>
> You probably have the privelege to do what you are trying to do in the procedure
> via a role. Grant the privelege directly to the owner of the procedure and
> it'll work.
>
> grant <priv> to <OWNER>;
>
This work fine. Thank you !