Using Predefined Roles

The roles in this section are defined automatically when the database is created. Table 18.1 contains the predefined roles and their descriptions.

Table 18.1. Oracle 9i Provided Roles and Descriptions
RoleDescription
CONNECTIncludes CREATE SESSION, ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE, CREATE TABLE, CREATE SYNONYM, and CREATE VIEW.
RESOURCEIncludes CREATE CLUSTER, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, and UNLIMITED TABLESPACE.
DBAIncludes all the system privileges WITH ADMIN OPTION as well as UNLIMITED TABLESPACE.
EXP_FULL_DATABASEProvides all the privileges required to perform full database exports and incremental database ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) 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.