Privileges That Allow You to Create Objects in Your Own Schema

Table 15.4 lists the privileges that allow you to create your own objects in the database. These privileges have been allocated to the CONNECT and RESOURCE roles. They allow you to connect to the database; to create a table, view, or snapshot; and to create a private database link, synonym, or snapshot.

Table 15-4. Privileges That Allow You to Create Objects in Your Own Schema

ALTER SESSION

CREATE CLUSTER

CREATE DATABASE LINK

CREATE PROCEDURE

CREATE SEQUENCE

CREATE SESSION

CREATE SNAPSHOT

CREATE SYNONYM

CREATE TABLE

CREATE TRIGGER

CREATE TYPE

CREATE VIEW

FORCE TRANSACTION

 

Tip

You may need more than one system privilege to perform an action. For example, you cannot create a sequence if you do not first have the CREATE SESSION privilege, which allows you to connect to the database. Also, note that you cannot create a table or index unless you have a quota on a tablespace or have the UNLIMITED TABLESPACE system privilege.

Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.