Resource Privileges in Oracle Database

If doesn’t have resource privileges, Doesn’t create the following objects:

SQL> select privilege from dba_sys_privs where grantee='RESOURCE';

CREATE TABLE
CREATE TYPE
CREATE TRIGGER
CREATE CLUSTER
CREATE SEQUENCE
CREATE OPERATOR
CREATE PROCEDURE
CREATE INDEXTYPE

Also we have unlimited tablespace within resource role.  Continue reading Resource Privileges in Oracle Database