Revoking Privileges for a List of Users

From InterBase
Jump to: navigation, search

Go Up to Revoking User Access


Use a comma-separated list of users to REVOKE access privileges for a number of users at the same time.

The following statement revokes INSERT and UPDATE privileges on the DEPARTMENTS table for users FRANCIS, BEATRICE, and HELGA:

REVOKE INSERT, UPDATE ON DEPARTMENTS FROM FRANCIS, BEATRICE, HELGA;

Advance To: