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.

Report message to a moderator

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: 68453
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 02 20:16:48 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.