Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Granting roles from stored procedure
In article <857668230.26980_at_dejanews.com>, hvanderz_at_ch2m.com writes
>In article ,
> sunil_at_ameya.com wrote:
>>
>> Chris Halioris wrote:
>> >
>> > Actually the stored procedure runs with the privileges of the user that
>> > created the procedure. Hence, if the account you compiled the procedure
>> > in does not have the privilege to issue the grant you are issuing, that
>> > would be your problem.
>>
>> Try Granting the Create Role to PROC_OWNER WITH ADMIN
>>
>
>Thanks for all the suggestions, but unfortunately, none of them have
>solved my problem. Any more ideas out there?
>
>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.
>
I think WLF needs the 'grant any role' privilege, and it may also need the to have the admin option on the role it is trying to grant.
-- Jim SmithReceived on Fri Mar 07 1997 - 00:00:00 CST