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.
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 |
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.