1Z0-062 · Question #315
What is pre-requisite to alter a role?
The correct answer is D. You should have the ALTER ANY ROLE system privilege. To modify an existing role in an Oracle database, a user must possess the specific system privilege designed for role alteration.
Question
What is pre-requisite to alter a role?
Options
- AYou should be granted the DBA role.
- BYou should set the OS_ROLES parameter to true.
- CYou should be granted the role with the GRANT OPTION.
- DYou should have the ALTER ANY ROLE system privilege.
How the community answered
(16 responses)- A6% (1)
- D94% (15)
Why each option
To modify an existing role in an Oracle database, a user must possess the specific system privilege designed for role alteration.
While the DBA role implicitly includes ALTER ANY ROLE, it is a broader role, and ALTER ANY ROLE is the direct and minimal privilege required to alter a role.
The OS_ROLES parameter controls whether roles are managed by the operating system, which is a database configuration setting and not a privilege requirement for altering roles.
Being granted a role with GRANT OPTION allows a user to grant that specific role to others, but it does not confer the ability to alter the definition or properties of the role itself.
The ALTER ANY ROLE system privilege is the specific and necessary prerequisite for a user to execute the ALTER ROLE statement and modify any role in the database, including its password or default status.
Concept tested: Oracle system privileges for role management
Source: https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/ALTER-ROLE.html
Topics
Community Discussion
No community discussion yet for this question.