Home » RDBMS Server » Security » revoke grant privilege from user's own object (oracle 10g)
revoke grant privilege from user's own object [message #301242] Tue, 19 February 2008 16:01 Go to next message
Messages: 2
Registered: July 2006
Junior Member
I need to (not want Smile )revoke a user's ability to grant to another user access to his/her own objects. For example, if scott creates a table "X", he should not be able to grant to anyone else access to this table. Is that possible?

Your answers/thoughts are truly appreciated.
Re: revoke grant privilege from user's own object [message #301311 is a reply to message #301242] Wed, 20 February 2008 00:45 Go to previous message
Michel Cadot
Messages: 65181
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't, owner has always the full power on his objects.
If you want to do this, you have to create a DDL trigger.

Previous Topic: last password change
Next Topic: What view in the data dictionary shows grants for procedures
Goto Forum:

Current Time: Mon Oct 16 21:23:46 CDT 2017

Total time taken to generate the page: 0.01675 seconds