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
hlavender
Messages: 2
Registered: July 2006
Junior Member
All-
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: 58856
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.

Regards
Michel
Previous Topic: user roles
Next Topic: What view in the data dictionary shows grants for procedures
Goto Forum:
  


Current Time: Thu Aug 21 15:38:16 CDT 2014

Total time taken to generate the page: 0.11294 seconds