Granting Multiple Privileges
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.
REFERENCES privileges cannot be assigned for views.