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
REVOKE privilege-list/ALL [ON resource-type resource-list] FROM authorization-id-list/ PUBLIC
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!