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;

Published by

Emrah Gümüş

Computer Engineer, Database Administrator, Full-stack Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.