Granting the EXECUTE Privilege on Functions and Procedures

Grant the privilege to run a procedure or user-defined function.

Prerequisites
Requires one of:
Task
To grant the EXECUTE privilege, enter:
GRANT EXECUTE
  ON procedure_name
  TO userID [,...]
Parent topic: Grant and Revoke Object-Level Privileges
Related reference
GRANT EXECUTE Statement