Which statement is true about the SCOTT user after he is granted this role?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Muhib

Muhib

B is the answer for this.