Revoking Privileges from Objects
From InterBase
Go Up to Revoking User Access
REVOKE can remove the access privileges for one or more procedures, triggers, or views. Precede each type of object by the correct keyword (PROCEDURE, TRIGGER, or VIEW) and separate lists of one object type with commas.
The following statement revokes INSERT and UPDATE privileges for the ACCOUNTS table from the MONEY_TRANSFER and ACCT_MAINT procedures and from the SHOW_USER trigger.
REVOKE INSERT, UPDATE ON ACCOUNTS FROM PROCEDURE MONEY_TRANSFER,
ACCT_MAINT TRIGGER SHOW_USER;