| Keyword | Meaning |
|---|---|
| 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.