View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD
has been granted the CONNECT and RESOURCE roles only. The database administrator
(DBA) grants MGR_ROLE to the user SKD by executing the command: SQL> GRANT
MGR_ROLE TO SKD WITH ADMIN OPTION; Which statement is true about the user SKD
after he/she is granted this role? See the Exhibit:
A.
The user SKD can grant only the MGR_ROLE role to other users, but not the privileges
in it
B.
The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the
grantor
C.
The user SKD can grant the privileges in the MGR_ROLE role to other users but not with
ADMIN OPTION
D.
The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot
revoke privileges from them
REVOKE
https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9020.htm#SQLRF01609
“To revoke a system privilege, you must have been granted the privilege with the ADMIN OPTION.
To revoke a role, you must have been granted the role with the ADMIN OPTION. You can revoke any role if you have the GRANT ANY ROLE system privilege.
To revoke an object privilege, you must previously have granted the object privilege to the user and role or you must have the GRANT ANY OBJECT PRIVILEGE system privilege. In the latter case, you can revoke any object privilege that was granted by the object owner or on behalf of the owner by a user with the GRANT ANY OBJECT PRIVILEGE. However, you cannot revoke an object privilege that was granted by way of a WITH GRANT OPTION grant.”