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;