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;