SQL> select GRANTEE,PRIVILEGE from DBA_SYS_PRIVS where GRANTEE = 'RESOURCE';GRANTEE                        PRIVILEGE
------------------------------ ----------------------------------------
RESOURCE                       CREATE CLUSTER
RESOURCE                       CREATE INDEXTYPE
RESOURCE                       CREATE OPERATOR
RESOURCE                       CREATE PROCEDURE
RESOURCE                       CREATE SEQUENCE
RESOURCE                       CREATE TABLE
RESOURCE                       CREATE TRIGGER
RESOURCE                       CREATE TYPE8 rows selectedSQL>