Like this?
Code:
SQL> SELECT * FROM dict WHERE table_name LIKE '%SYS%PRIV%';
TABLE_NAME COMMENTS
------------------------------ ------------------------------------------------------------
USER_RSRC_MANAGER_SYSTEM_PRIVS system privileges for the resource manager for the user
USER_SYS_PRIVS System privileges granted to current user
ROLE_SYS_PRIVS System privileges granted to roles
Elapsed: 00:00:00.94
SQL>
LIDXPNN - t31a=> SELECT * FROM dict WHERE table_name LIKE '%ROLE%';
TABLE_NAME COMMENTS
------------------------------ --------------------------------------------
USER_ROLE_PRIVS Roles granted to current user
ROLE_ROLE_PRIVS Roles which are granted to roles
ROLE_SYS_PRIVS System privileges granted to roles
ROLE_TAB_PRIVS Table privileges granted to roles
SESSION_ROLES Roles which the user currently has enabled.
10 rows selected.
Elapsed: 00:00:00.71