Granting Privileges to a List of Procedures
From InterBase
Go Up to Multiple Privileges and Multiple Grantees
To assign privileges to a several procedures at once, provide a comma-separated list of procedures following the word PROCEDURE
in the GRANT
statement.
The following statement gives INSERT
and UPDATE
privileges for the DEPARTMENTS
table to the procedures, ACCT_MAINT
, and MONEY_TRANSFER
:
GRANT INSERT, UPDATE ON DEPARTMENTS TO PROCEDURE ACCT_MAINT,
MONEY_TRANSFER;