Revoking Multiple Privileges

From InterBase
Jump to: navigation, search

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.

Advance To: