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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset