Revoking Privileges from Objects

From InterBase
Jump to: navigation, search

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;

Advance To: