Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP user?

See the Exhibit to observe the roles assigned to the SL_REP user: Which statement is true
about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP user?

See the Exhibit to observe the roles assigned to the SL_REP user: Which statement is true
about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP user?

A.
The user cannot user the role until the DBA enables it explicitly

B.
The user can start using the role immediately without any changes

C.
The user can grant the role to other users

D.
The user must enable the role explicitly



Leave a Reply 1

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


MJ

MJ

Correct answer here is A.

SL_REP has insufficient privilege to enable the role to itself. Only a user with DBA grant or SYS / SYSTEM can do this.