Change the password requirements for a user role.
Syntax:
Add password to a role: ALTER ROLE role IDENTIFIED BY password Remove password from a role: ALTER ROLE role NOT IDENTIFIED Change role to an application role: ALTER ROLE role IDENTIFIED USING [schema.]package Authorised by the OS: ALTER ROLE role IDENTIFIED EXTERNALLY Authorised by Directory Service: ALTER ROLE role IDENTIFIED GLOBALLY
Before you alter a role to IDENTIFIED GLOBALLY, you must revoke the role from all users, roles, and PUBLIC (apart from the user who is currently altering the role.) Also if any roles have been granted to the role IDENTIFIED EXTERNALLY then revoke those grants.
Changing a role will not affect any user sessions that are already running with that role enabled.
"True leadership is the art of changing a group from what it is to what it ought to be" ~ Virginia Allan
Related Oracle Commands:
PROFILE - ALTER PROFILE
ROLE - CREATE ROLE
ROLE - SET ROLE
ROLE - DROP ROLE
Related Views:
USER_RESOURCE_LIMITS DBA_RGROUP DBA_ROLES DBA_ROLE_PRIVS USER_ROLE_PRIVS ROLE_ROLE_PRIVS DBA_SYS_PRIVS USER_SYS_PRIVS ROLE_SYS_PRIVS