Query role_sys_privs for privilege name : role_sys_privs « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. role_sys_privs

SQL>
SQL> SELECT *
  2  FROM   role_sys_privs
  3  WHERE  privilege = 'CREATE SESSION'
  4  and    rownum < 50;

ROLE                           PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
DBA                            CREATE SESSION                           YES

SQL>
SQL>