Granting the Privilege To Run a Procedure

Grant the privilege to execute or call a procedure.

Prerequisites

At least one of these conditions:

You created the table.
You have been granted privileges on the table with the ADMIN OPTION.
You have been granted the EXECUTE ANY PROCEDURE system privilege.
You have been granted LOAD and TRUNCATE object privileges.
You have been granted the MANAGE ANY OBJECT PRIVILEGE system privilege. If the LOAD or TRUNCATE object privilege is granted using the WITH GRANT OPTION clause, the grantee can then grant the object privilege to other users, but is limited to those tables specified in the original GRANT statement. Under this scenario, the grantee does not need the MANAGE ANY OBJECT PRIVILEGE system privilege.

Task

Procedures execute with the privileges of their owner. Any procedure that updates information on a table executes successfully only if the owner of the procedure has UPDATE privileges on the table.

As long as the procedure owner has the proper privileges, the procedure executes successfully when called by any user assigned privilege to execute it, whether or not he or she has privileges on the underlying table. You can use procedures to allow users to carry out well-defined activities on a table, without having any general privileges on the table.

To grant the EXECUTE privilege, enter:

GRANT EXECUTE ON procedure_name
TO usreID