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.
Role | Description |
---|---|
CONNECT | Includes CREATE SESSION, ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE, CREATE TABLE, CREATE SYNONYM, and CREATE VIEW. |
RESOURCE | Includes CREATE CLUSTER, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, and UNLIMITED TABLESPACE. |
DBA | Includes all the system privileges WITH ADMIN OPTION as well as UNLIMITED TABLESPACE. |
EXP_FULL_DATABASE | Provides 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.