Granting Privileges to Execute Stored Procedures

Go Up to Planning Security

To use a stored procedure, users or other stored procedures must have
EXECUTE privilege for it, using the following GRANT syntax:

GRANT EXECUTE ON PROCEDURE procname TO {<object> | <userlist>}
<object> = {
 PROCEDURE procname
 | TRIGGER trigname
 | VIEW viewname
 | PUBLIC
 }
 [, <object> …]
<userlist> = {
[USER] username
| rolename
| UNIX_user
} [, <userlist> …] [WITH GRANT OPTION]

You must give EXECUTE privileges on a stored procedure to any procedure or trigger that calls that stored procedure if the caller’s owner is not the same as the owner of the called procedure.

Note: If you grant privileges to PUBLIC, you cannot specify additional users or objects as grantees in the same statement.

The following statement grants EXECUTE privilege for the FUND_BALANCE procedure to two users, NKOMO, and SUSAN, and to two procedures, ACCT_MAINT, and MONEY_TRANSFER:

GRANT EXECUTE ON PROCEDURE FUND_BALANCE TO NKOMO, SUSAN, PROCEDURE
 ACCT_MAINT, MONEY_TRANSFER;