| |
GeekInterview.com > Interview Questions > Oracle
| Print | |
Question: Revoking Priviledge
Answer: Lets follow the following structure of granting priviledge..
A -> B -> C -> D -> E
If we revoke priviledge from C, then what happens with D and E. |
| October 10, 2008 23:44:35 |
#1 |
| rajendra_thanekar |
Member Since: April 2007 Total Comments: 13 |
RE: Revoking Priviledge
|
| hi, It depends upon the type of privilege you are revoking. Is it object priviledge or system priviledge. There is one major difference in the revocation of object privileges and system privileges. With objects, if you revoke a privilege from a user who had been granted it previously with the with grant option,in this case the revoke operation will affect not only the user that you are revoking the privilege from, but all other users who that user had granted privileges to will have those privileges revoked as well. Cascade revoke effect will be observed only in case of object priviledge and not with system priviledge. |
| |
Back To Question | |
