SET ROLE

Choose the current user role(s).

Syntax:

   SET ROLE role [IDENTIFIED BY password][,…]

   SET ROLE ALL [EXCEPT role,…]

   SET ROLE NONE

Example

SET ROLE db_user, db_superuser;

“Anyone can hold the helm when the sea is calm” ~ Publius Syrus

Related Oracle 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