ALTER ROLE
ALTER ROLErole_name
{NOT IDENTIFIED | IDENTIFIED BYpassword
| IDENTIFIED EXTERNALLY | IDENTIFIED GLOBALLY }
Changes the authorization level required to enable a role (role_name).
Specifies that a user granted the role does not need to be verified when enabling it.
Specifies that the password must be provided when enabling the role.
Specifies that the operating system verifies the user enabling the role.
Specifies that the Oracle Security Server verifies the user enabling the role.