|ALL PRIVILEGES||database-related privileges are affected.|
|MONITOR PRIVILEGES||system monitoring privileges are affected.|
If you violate either one of the following restrictions, a failure response occurs:
- Use REVOKE MONITOR to specify an ON object clause.
- Use any other type of REVOKE statement and do not specify an ON object clause.
The REVOKE statement takes effect as soon as the recipient issues their next statement.