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






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. Object Privileges
REVOKE INSERT ON tableName FROM userName;

REVOKE SELECT ON schemaName.tableName FROM 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