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
A. The privilege must be granted only by roles
B. The privilege is granted by roles and users
C. The user role cannot be removed once given
D. By restricting the user access to the roles
Answer:A
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
A. The privilege must be granted only by roles B. The privilege is granted by roles and users C. The user role cannot be removed once given D. By restricting the user access to the roles
Explanation:The current role associated with a session can be set by executing set role role name. The specified role must have been granted to the user, else the set role statement fails. Sanfoundry Global Education & Learning Series – Database Management System.