Resource Privileges in Oracle Database

If you don’t have resource privileges in oracle databases, you don’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, you must have unlimited tablespace within the resource role. 

You can use the following syntax to give resource privileges:

SQL> grant resource to user;