use: select * from dba_tab_privs;
resource,DBA are oralce system roles.
drop any table,create any procedure are system privielges.
run this first:
SQL> set long 999999
and then run the DBMS_METADATA command and you should be able to see the entire content.
Also, if you wanted to check the privileges assigned to a role , you can use below:
select privilege from dba_sys_privs where grantee='ROLE1';
To check all the roles assigned to this role, use this:
select granted_role from dba_role_privs where grantee='ROLE1';