Oracle PL/SQL/System Tables Views/USER ROLE PRIVS

Lists the roles that have been granted to the user

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>

See which roles are available for you

SQL> --See which roles are available for you
SQL>
SQL> SELECT GRANTED_ROLE FROM USER_ROLE_PRIVS;
GRANTED_ROLE
------------------------------
DBA
SQL>
SQL>