Varieties of schema object privileges
- ALTER
Changes the definition of the object.
- DEBUG
Accesses PL/SQL code or information about SQL statements that access the object directly through a debugger. New with Oracle9i.
- DELETE
Removes rows from the object.
- 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. New with Oracle9i.
- INSERT
Adds new rows to the object.
- REFERENCES
Creates a constraint that references the object.
- SELECT
Queries the object.
- UNDER
Creates a subobject under the level of an object. New with Oracle9i.
- UPDATE
Changes existing data in the object.