Granting Object Privileges to a User : Object Privileges « User Privilege « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. Object Privileges
GRANT SELECT, INSERT, UPDATE ON schemaName.objectName TO userName;
GRANT SELECT ON store.employees TO userName;

GRANT UPDATE (last_name, salary) ON store.employee TO userName;








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