Syntax

Semantics

The keywords, parameters, and clauses in the ALTERROLE statement all have the same meaning as in the CREATEROLE statement.

Notes:

When you alter a role, user sessions in which the role is already enabled are not affected.

If you change a role identified by password to an application role (with the USINGpackage clause), password information associated with the role is lost. Oracle will use the new authentication mechanism the next time the role is to be enabled.

If you have the ALTERANYROLE system privilege and you change a role that is IDENTIFIEDGLOBALLY to IDENTIFIEDBYpassword, IDENTIFIEDEXTERNALLY, or NOTIDENTIFIED, then Oracle grants you the altered role with the ADMINOPTION, as it would have if you had created the role identified nonglobally.