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. 

You can use the following syntax:

SQL> grant resource to user;

Published by

Emrah Gümüş

Computer Engineer

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.