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 must enable the role explicitly
B.
The user can grant the role to other users
C.
The user cannot user the role until the DBA enables it explicitly
D.
The user can start using the role immediately without any changes
How can he explicitly provide the role to himself being not a dba???
Login to SQL*PLUS as SL_REP then issue this command:
SQL>SET ROLE select_catalog_role;
Not to provide but to enable with the command:
set role SELECT_CATALOG_ROLE;