Re: Granting roles from stored procedure

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.

TIA for your help.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet