Use the GRANT option to enable a user to grant a privilege to another user : Object Privileges « User Privilege « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. Object Privileges
GRANT SELECT ON store.customers TO steve WITH GRANT OPTION;








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