Examples

Example 1: Revoke SELECT privileges on table EMPLOYEE from user ENGLES.

   REVOKE SELECT
     ON TABLE EMPLOYEE
     FROM ENGLES

Example 2: Revoke update privileges on table EMPLOYEE previously granted to all users. Note that grants to specific users are not affected.

   REVOKE UPDATE
     ON TABLE EMPLOYEE
     FROM PUBLIC

Example 3: Revoke all privileges on table EMPLOYEE from users PELLOW and ANDERSON.

   REVOKE ALL
     ON TABLE  EMPLOYEE
     FROM PELLOW, ANDERSON

Example 4: Revoke the privilege to update column_1 in VIEW1 from FRED.

   REVOKE UPDATE(column_1)
     ON VIEW1
     FROM FRED