
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.