Revoking Priviledge

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.

todeepakmalhotra
Profile Answers by todeepakmalhotra Questions by todeepakmalhotra
Sep 30th, 2008
1
2504

Questions by todeepakmalhotra answers by todeepakmalhotra

Oracle

Answer

Showing Answers 1 - 1 of 1 Answers

rajendra_thanekar
Profile Answers by rajendra_thanekar

Oct 20th, 2008

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.