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






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>








30.56.role_sys_privs
30.56.1.Query role_sys_privs for privilege name