| Object Privilege | Table | View | Sequence | Procedure/Function | SQL Statements Permitted |
|---|---|---|---|---|---|
| ALTER |
(1) |
(1) |
ALTER object (table or sequence) | ||
| DELETE |
(1) |
(1) |
DELETE FROM object (table or view) | ||
| EXECUTE |
(1)(4) |
EXECUTE object (procedure or function). | |||
| INDEX |
(3) (2) |
CREATE INDEX ON object (tables only) | |||
| INSERT |
(1) |
(1) |
INSERT INTO object (table or view) | ||
| REFERENCES |
(3) (2) |
CREATE or ALTER TABLE statement defining a FOREIGN KEY integrity constraint on object (tables only) | |||
| SELECT |
(1) |
(3) (2) |
(1) |
SELECT...FROM object (table, view, or snapshot). SQL statements using a sequence | |
| UPDATE |
(1) |
(1) |
UPDATE object (table or view) | ||
|
1. Can also be granted for snapshots.
2. Privilege cannot be granted to a role. 3. Includes stand-alone stored procedures and functions, and public package constructs. 4. Execute: for types, snapshots, java classes, java sources |
|||||