Multiple choice

As SYSDBA TOM created the PAYCLERK role and granted the role to JOHN. JOHN in turn attempts to modify the authentication method of the PAYCLERK role from SALARY to NOT IDENTIFIED, but when doing so he receives the insufficient privilege error as shown:

SQL> connect JOHN/crusader

Connected.

SQL> alter role payclerk not identified;

alter role payclerk not identified

*

ERROR at line 1:

ORA-01031: insufficient privileges

Which privilege does JOHN require to modify the authentication method of the PAYCLERK role?

  1. ALTER ANY ROLE

  2. MANAGE ANY ROLE

  3. UPDATE ANY ROLE

  4. MODIFY ANY ROLE
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To modify a role's authentication method, a user needs the ALTER ANY ROLE system privilege. JOHN only has the PAYCLERK role granted to him, but this doesn't include the privilege to alter the role's properties. Option B (MANAGE ANY ROLE) doesn't exist in Oracle. Options C and D are also non-existent privilege names. Only SYSDBA or a user with ALTER ANY ROLE can change role authentication methods.

Keep practicing — related questions