To find all Sys Priviliges under a role in Oracle 10g

Select privilege from DBA_SYS_PRIVS where grantee like 'RESOURCE' order by privilege;

RESOURCE ------------------------

create cluster create indextype create operator create procedure create sequence create table create trigger create type