Home » RDBMS Server » Security » Grant and Revoke
Grant and Revoke [message #34587] Tue, 21 December 2004 21:19 Go to next message
ramu
Messages: 82
Registered: February 2001
Member
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
Ramu
Re: Grant and Revoke [message #34589 is a reply to message #34587] Tue, 21 December 2004 23:07 Go to previous message
sri
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: Thu Mar 28 14:46:31 CDT 2024