Home » RDBMS Server » Security » Grant and Revoke
Grant and Revoke [message #34587] Tue, 21 December 2004 21:19 Go to next message
Messages: 82
Registered: February 2001
Hi all,

User A has given select privilege on User B with grant option and User B in turn has given select privilege to user C. How to revoke with grant option by A. Will that applicable to all the users or only to User B he has given. Though i revoked select from User B. Still i am able to select the data on user A's object . Can anyone give me the best solution with examples plz. I need the great help from you all

Thanks and Regards
Re: Grant and Revoke [message #34589 is a reply to message #34587] Tue, 21 December 2004 23:07 Go to previous message
Messages: 154
Registered: February 2000
Senior Member
Revoking the priviledges does not cascade.

Ie If UserA has granted a priviledge to User b ,, later
if the rights has been revoked from User A then it will not be revoked from User B
Previous Topic: how to add a new user?
Next Topic: Creating a new user and grant dba
Goto Forum:

Current Time: Mon Aug 15 08:54:32 CDT 2022