Oracle PL/SQL/System Tables Views/USER ROLE PRIVS
Lists the roles that have been granted to the user
<source lang="sql">
SQL> --Lists the roles that have been granted to the user SQL> SQL> desc USER_ROLE_PRIVS;
Name Null? Type ----------------------------------------------------------------------------------------------------- -------- -------------------------------------------------------------------- USERNAME VARCHAR2(30) GRANTED_ROLE VARCHAR2(30) ADMIN_OPTION VARCHAR2(3) DEFAULT_ROLE VARCHAR2(3) OS_GRANTED VARCHAR2(3)
SQL> SQL> select * from USER_ROLE_PRIVS where rownum < 200; USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ --- --- ---
sqle DBA NO YES NO SQL> SQL>
</source>
See which roles are available for you
<source lang="sql">
SQL> --See which roles are available for you SQL> SQL> SELECT GRANTED_ROLE FROM USER_ROLE_PRIVS; GRANTED_ROLE
DBA SQL> SQL>
</source>