Choose a topic
Object privilegesAn object privilege is the right to perform a particular action on an object or to access another user's object. Objects include tables, views, materialized views, indexes, synonyms, sequences, cache groups, replication schemes and PL/SQL functions, procedures and packages.An object's owner has all object privileges for that object, and those privileges cannot be revoked. The object's owner can grant object privileges for that object to other database users. A user with ADMIN privilege can grant and revoke object privileges from users who do not own the objects on which the privileges are granted.Table 7-2 Object privilegesPrivilegeObject typeDescriptionDELETETableEnables a user to delete from a table.EXECUTEPL/SQL package, procedure or functionEnables a user to execute a PL/SQL package, procedure or function directly.FLUSHCache groupEnables a user to flush a cache group.INDEXTable or materialized viewEnables a user to create an index on a table or materialized view.INSERTTable or synonymEnables a user to insert into a table or into the table through a synonym.LOADCache groupEnables a user to load a cache group.REFERENCESTable or materialized viewEnables a user to create a foreign key dependency on a table or materialized view.The REFERENCES privilege on a parent table implicitly grants SELECT privilege on the parent table.REFRESHCache groupEnables a user to refresh a cache group.SELECTTable, sequence, view, materialized view, or synonymEnables a user to select from a table, sequence, view, materialized view, or synonym.The SELECT privilege enables a user to perform all operations on a sequence.A user can be granted the SELECT privilege on a synonym or a view without being explicitly granted the SELECT privilege on the originating table.UNLOADCache groupEnables a user to unload a cache group.UPDATETableEnables a user to update a table.