Use WITH ADMIN OPTION

WITH ADMIN OPTION allows a user to grant a privilege to another user.

GRANT EXECUTE ANY PROCEDURE TO tom WITH ADMIN OPTION;

EXECUTE ANY PROCEDURE can then be granted to another user by tom. The following example connects as tom to SQLPlus and grants EXECUTE ANY PROCEDURE to Jerry:

CONNECT tom/password
GRANT EXECUTE ANY PROCEDURE TO Jerry;

You can grant a privilege to all users by granting to PUBLIC.

CONNECT system/manager
GRANT EXECUTE ANY PROCEDURE TO PUBLIC;

1. System Privileges
2. Use WITH ADMIN OPTION
3. Checking System Privileges Granted to a User
4. Revoking System Privileges from a User