SET ROLE

Choose the current user role(s).

Syntax:

   SET ROLE role_name [IDENTIFIED BY password][,...]
   SET ROLE ALL [EXCEPT role_name,...]
   SET ROLE NONE

Example

SET ROLE db_user, db_superuser;

"Anyone can hold the helm when the sea is calm." - Publius Syrus

Related Commands:

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