Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
Security
|
97
EXECUTE
Compiles or executes a procedure or function in the
object or accesses a program object declared in the object.
FLASHBACK
Executes a flashback query on the object.
INSERT
Adds new rows to the object.
REFERENCES
Creates a constraint that references the object.
SELECT
Queries the object.
UNDER
Creates a subobject at the level below the object.
UPDATE
Changes existing data in the object.
Each type of schema object is listed in the following sec-
tions, along with its unique privileges and any applicable
common privileges from the above list.
Directories
Provides privileges to perform operations on directories. Unique
privileges are:
READ
Reads files in a directory.
WRITE
Writes to files in a directory, with the exception of BFILEs.
Applies to external tables in the directory.
There are no common privileges.
External tables
Provides privileges to perform operations on external tables.
There are no unique privileges. Common privileges are ALTER
and SELECT.
98
|
Oracle DBA Pocket Guide
Indextypes
Provides privileges to perform operations on indextype objects.
There are no unique privileges. The only common privilege is
EXECUTE.
Libraries
Provides privileges to perform operations on libraries. There are
no unique privileges. Common privileges are CREATE and
DROP.
Materialized views
Provides privileges to perform ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843