Home -> Usenet -> comp.databases.oracle -> dba can't grant object permissions!

dba can't grant object permissions!

From: James Dickson <James.Dickson_at_mail.esrin.esa.it>
Date: 1996/11/20
Message-ID: <3292E0D6.1A71_at_mail.esrin.esa.it>#1/1 







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












Original text of this message