Revoking Multiple Privileges
From InterBase
Go Up to Revoking User Access
To remove some, but not all, of the access privileges assigned to a user or procedure, list the privileges to remove, separating them with commas. For example, the following statement removes the INSERT and UPDATE privileges for the DEPARTMENTS table from a user, LI:
REVOKE INSERT, UPDATE ON DEPARTMENTS FROM LI;
The next statement removes INSERT and DELETE privileges for the ACCOUNTS table from a stored procedure, MONEY_TRANSFER:
REVOKE INSERT, DELETE ON ACCOUNTS FROM PROCEDURE MONEY_TRANSFER;
Any combination of previously assigned SELECT, DELETE, INSERT, and UPDATE privileges can be revoked.