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