1Z0-052 · Question #61
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?
The correct answer is A. The user must enable the role explicitly. This question tests how Oracle role grants behave when a role is not configured as a default role for the grantee.
Question
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?
Exhibit
Options
- AThe user must enable the role explicitly
- BThe user can grant the role to other users
- CThe user cannot user the role until the DBA enables it explicitly
- DThe user can start using the role immediately without any changes
How the community answered
(38 responses)- A82% (31)
- B3% (1)
- C11% (4)
- D5% (2)
Why each option
This question tests how Oracle role grants behave when a role is not configured as a default role for the grantee.
When SELECT_CATALOG_ROLE is granted to a user but is not set as a default role, it is inactive at login. The user must issue a SET ROLE command to explicitly enable it before the privileges it provides can be used. This is standard Oracle role activation behavior for non-default roles.
A grantee can re-grant a role to other users only if it was granted WITH ADMIN OPTION, which is not indicated in this scenario.
It is the user who enables a non-default role via SET ROLE, not the DBA; the DBA has no activation step to perform.
A non-default role is not active immediately upon session login; the user must explicitly enable it before its privileges take effect.
Concept tested: Oracle non-default role explicit activation
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-privilege-and-role-authorization.html
Topics
Community Discussion
No community discussion yet for this question.