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
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.