ALTER ROLE

Purpose

Used to modify the authentication method of a role.

Syntax

ALTER ROLE role_name
{ NOT IDENTIFIED
| IDENTIFIED BY password
} ;

Parameters

Examples

• Create a role named role1 and change the authentication method of the role to use password authentication with the password password1.

  obclient> CREATE ROLE role1;
  
  obclient> ALTER ROLE role1 IDENTIFIED BY password1;
  

• Change the authentication password of the role role1 to password2.

  obclient> ALTER ROLE role1 IDENTIFIED BY password2;
  

• Change the role role1 to not use any authentication method.

  obclient> ALTER ROLE role1 NOT IDENTIFIED;
  

References

• CREATE ROLE
• DROP ROLE