Oracle role: RESOURCE

select
   privilege,
   admin_option
from
   dba_sys_privs
where
   grantee = 'RESOURCE';
--
-- PRIVILEGE                                ADM
-- ---------------------------------------- ---
-- CREATE SEQUENCE                          NO 
-- CREATE PROCEDURE                         NO 
-- CREATE CLUSTER                           NO 
-- CREATE INDEXTYPE                         NO 
-- CREATE OPERATOR                          NO 
-- CREATE TYPE                              NO 
-- CREATE TRIGGER                           NO 
-- CREATE TABLE                             NO 

select count(*) from dba_tab_privs where grantee = 'RESOURCE';
--
-- COUNT(*)
-- --------
--        0