16.20 - Rules for Using REVOKE (Monitor Form) - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Data Control Language

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1149-162K
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.