View the Exhibit to observe the privileges granted to the MGR_ROLE role. The SCOTT user has been granted the CONNECT and RESOURCE roles only.
The database administrator (DBA) grants MGR_ROLE to the SCOTT user by using this command:
SQL> GRANT MGR_ROLE TO SCOTT WITH ADMIN OPTION;
Which statement is true about the SCOTT user after he is granted this role?
A.
The SCOTT user can grant the MGR_ROLE role and the privileges in it to other users.
B.
The SCOTT user can grant only the MGR_ROLE role to other users but not the privileges in it.
C.
The SCOTT user can grant the privileges in the MGR_ROLE role to other users but cannot revoke privileges from them.
D.
The SCOTT user can grant the privileges in the MGR_ROLE role to other users but not with ADMIN_OPTION.
B is the answer for this.