Oracle PL/SQL Tutorial/System Tables Data Dictionary/role sys privs
Query role_sys_privs for privilege name
<source lang="sql">
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></source>