ROLE 을 말씀하시는건가;;
DBA_ROLES 를 한번 보심이;;

아니면
USER_ROLE_PRIVS 를 보셔도 될듯

USER_ROLE_PRIVS, ROLE_SYS_PRIVS로 보시면 될 것 같네요.

dbs_sys_privs, dba_role_priv 정도 보시면 됩니다.
role 을 부여 받은게 있으면 마찬가지로 또 찾으셔야 합니다.

SYS>select * from dba_role_privs where grantee = 'SCOTT';

GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
SCOTT DBA NO YES
SCOTT CONNECT NO YES
SCOTT RESOURCE NO YES

SYS>select * from dba_sys_privs where grantee='SCOTT';

GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
SCOTT ADVISOR NO
SCOTT QUERY REWRITE NO
SCOTT ALTER ANY TABLE NO
SCOTT CREATE ANY PROCEDURE NO
SCOTT UNLIMITED TABLESPACE NO
SCOTT CREATE MATERIALIZED VIEW NO

..
SYS>select * from dba_sys_privs where grantee='DBA';

GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
DBA ADVISOR YES
DBA AUDIT ANY YES
....