Revoking Privileges for a List of Users

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:

• Revoking Privileges for a Role