Object Privileges : Object Privileges « User Privilege « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. Object Privileges

An object privilege allows a user to perform certain actions on database objects, such as executing DML statements on tables.

Commonly Used Object Privileges

Object PrivilegeAllows a User to
SELECTPerform a select
INSERTPerform an insert
UPDATEPerform an update
DELETEPerform a delete
EXECUTEExecute a stored procedure










36.5.Object Privileges
36.5.1.Object Privileges
36.5.2.Granting Object Privileges to a User
36.5.3.Use the GRANT option to enable a user to grant a privilege to another user
36.5.4.Revoking Object Privileges
36.5.5.Grant a procedure to public and then execute it
36.5.6.Procedure for current user