17.05 - Rules for Using REVOKE (Monitor Form) - Teradata Database

Teradata Vantageā„¢ - SQL Data Control Language

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1149-170K
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.