ALTER ROLE

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

 
Copyright © 1999-2024 SS64.com
Some rights reserved