Re: dba can't grant object permissions!

James Dickson wrote:
>
> I am trying to grant execute on a procedure that belongs
> to one user to another user, i.e. something like this:
>
> SQLDBA> GRANT EXECUTE ON "TOM"."TOMSTHING" TO "HARRY";
>
> and I'm getting the error:
> ORA-01031: insufficient privileges
>
> even though as DBA I have the 'grant any privilege' privilege.
>
> ...
> James james_at_valhall.esrin.esa.it

The GRANT ANY PRIVILEGE privilege says that you can grant any system privilege. Oracle does not allows any user to grant object privileges on someone else's objects, unless those privileges have been granted by the owner using WITH GRANT OPTION.

In the situations where I have wanted to do this, I switch to the user by resetting their password as you describe.

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com