Granting Privileges to a List of Procedures

From InterBase
Jump to: navigation, search

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;

Advance To: