Home Oracle Commands

ALTER ROLE

Change the password requirements for a user role.

Syntax:

   ALTER ROLE role_name NOT IDENTIFIED
   ALTER ROLE role_name IDENTIFIED BY password
   ALTER ROLE role_name IDENTIFIED EXTERNALLY
   ALTER ROLE role_name IDENTIFIED GLOBALLY

"True leadership is the art of changing a group from what it is to what it ought to be." - Virginia Allan

Related 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



Back to the Top

Simon Sheppard
SS64.com