Use WITH ADMIN OPTION to enable a user to grant a privilege to another user : System Privileges « User Privilege « Oracle PL/SQL Tutorial






GRANT EXECUTE ANY PROCEDURE TO yourUserName WITH ADMIN OPTION;








36.9.System Privileges
36.9.1.System Privileges
36.9.2.Granting System Privileges to a User
36.9.3.Use WITH ADMIN OPTION to enable a user to grant a privilege to another user
36.9.4.The EXECUTE ANY PROCEDURE can then be granted to another user
36.9.5.Grant a privilege to all users by granting to PUBLIC
36.9.6.Revoke system privileges from a user using REVOKE