Re: dba can't grant object permissions!

"GRANT ANY PRIVILEGE" grants SYSTEM privileges only. In order to grant object privileges you may want to user "GRANT EXECUTE ANY PROCEDURE".
  Kittu.

James Dickson (James.Dickson_at_mail.esrin.esa.it) 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.
 

: As a workaround I could change TOM's password,
: log in as TOM, grant execute priv to HARRY,
: log back in as DBA and change TOM's password back
: to what it was (I don't know what it is but I can
: see the encoded value). This is very messy. Is there
: an easier way, like granting myself some other privilege?
: Surely the DBA should be able to easily grant execute
: permissions on any users' objects to any other user?
 

: Thanks,
: James james_at_valhall.esrin.esa.it
Received on Wed Nov 20 1996 - 00:00:00 CET