Check for Role Permissions

select grantee,owner,table_name from dba_tab_privs
where privilege in ('ALTER','REFERENCES','INDEX')
and grantee not in ('DBA','SYSTEM','LBACSYS','XDBADMIN','XDB_ADMIN')
and table_name not in ('SDO_IDX_TAB_SEQUENCE','XDB$ACL')
and grantee not in (select grantee from dba_role_privs where granted_role='DBA')
and grantee not in (select owner from dba_objects);