| Grant and Revoke [message #34587] |
Tue, 21 December 2004 21:19  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
