Re: Granting roles from stored procedure

hvanderz_at_ch2m.com wrote:

>
>For those missing the first post, here's a summary:
>
>I am trying to execute a grant role command from within a stored
>procedure. The owner of the stored procedure is WLF. WLF is able to
>grant the role from the SQL prompt but not from within the procedure.
>The error is ORA-00990: missing or invalid privilege. WLF has had the
>roles granted to it with the admin option, as well as the create role
>with admin option.
>
>TIA for your help.

You don't mention which version of the database you are on.

Try the dbms_session.set_role procedure.

Jared Still
ValueRx/RxNet
Oracle DBA - DG/UX Sysadmin - Part Time Perl Evangelist ;) jared_at_psnw.com
stillj_at_valuerx.com Received on Mon Mar 10 1997 - 00:00:00 CST