Granting Multiple Privileges

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:

GRANTINSERT,UPDATEONDEPARTMENTSTOLI;

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 TRIGGERorVIEW keyword.

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

GRANTINSERT,UPDATEONACCOUNTSTOPROCEDUREMONEY_TRANSFER;

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