Granting Privileges to Execute Stored Procedures
From InterBase
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
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;