Revoking Privileges for a List of Users
From InterBase
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;