Explanation:A user has an authorization if and only if there is a path from the root of the authorization graph down to the node representing the user. 9. Which of the following is used to avoid cascading of authorizations from the user ?
A. Granted by current role
B. Revoke select on department from Amit, Satoshi restrict;
C. Revoke grant option for select on department from Amit;
D. Revoke select on department from Amit, Satoshi cascade;
Answer:A
Explanation:A user has an authorization if and only if there is a path from the root of the authorization graph down to the node representing the user. 9. Which of the following is used to avoid cascading of authorizations from the user ?
A. Granted by current role B. Revoke select on department from Amit, Satoshi restrict; C. Revoke grant option for select on department from Amit; D. Revoke select on department from Amit, Satoshi cascade;
Explanation:The revoke statement may specify restrict in order to prevent cascading revocation.The keyword cascade can be used instead of restrict to indicate that revocation should cascade. 10. The granting and revoking of roles by the user may cause some confusions when that user role is revoked .To overcome the above situation