Re: Granting roles from stored procedure

> 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.

you will need to explicitly grant 'grant any role' to the procedure owner, i.e. by doing a 'grant grant any role to WLF;'. It must be explicit as stored procedures do not recognise grants which have been issued through a role. You have to use grant any role as there is no facility to allow a user to grant specific roles. Received on Mon Mar 10 1997 - 00:00:00 CST