CREATE ROLE

Create a user role.

Syntax:

   CREATE ROLE role_name [NOT IDENTIFIED]
   CREATE ROLE role_name [IDENTIFIED BY password]
   CREATE ROLE role_name [IDENTIFIED EXTERNALLY]
   CREATE ROLE role_name [IDENTIFIED GLOBALLY]

"A man's gotta know his limitations." - Clint Eastwood, as Dirty Harry

Related Commands:

PROFILE - ALTER PROFILE
ROLE - ALTER 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