DB2 - SQL Revoke Statement

The SQL Revoke statement is used to take away a certain privilege from a users.

Only privileges previously granted can be revoked.

It can be issued only by the granter or by a SYSADM users

Syntax:

REVOKE privilege-list/ALL
    [ON resource-type resource-list]
      FROM authorization-id-list/ PUBLIC

Example:

To revoke the SELECT privilege on the EMPLOYEE table from the user TWIN

REVOKE SELECT
      ON EMPLOYEE FROM USER TWIN

If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!