Question

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;

I have been asked this question in exam.

Question is taken from Authorizations topic in division SQL : Queries, Constraints and Triggers of Database Management

Answer 1

The correct option is (b) Revoke select on department from Amit, Satoshi restrict;

For 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.