Granting Multiple Privileges

From InterBase
Jump to: navigation, search

Go Up to Multiple Privileges and Multiple Grantees


To give a user several privileges on a table, separate the granted privileges with commas in the GRANT statement. For example, the following statement assigns INSERT and UPDATE privileges for the DEPARTMENTS table to a user, LI:

GRANT INSERT, UPDATE ON DEPARTMENTS TO LI;

To grant a set of privileges to a procedure, place the PROCEDURE keyword before the procedure name. Similarly, to grant privileges to a trigger or view, precede the object name with the TRIGGER or VIEW keyword.

The following statement assigns INSERT and UPDATE privileges for the ACCOUNTS table to the MONEY_TRANSFER procedure:

GRANT INSERT, UPDATE ON ACCOUNTS TO PROCEDURE MONEY_TRANSFER;

The GRANT statement can assign any combination of SELECT, DELETE, INSERT, UPDATE, and REFERENCESprivileges. EXECUTE privileges must be assigned in a separate statement.

Note: REFERENCES privileges cannot be assigned for views.

Advance To: