16.20 - Monitor Privileges - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Data Control Language

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
Programming Reference

GRANT MONITOR takes effect immediately when the grantee issues his next statement. It is unnecessary to log out to receive the monitor privilege just granted.

GRANT MONITOR does not have an ON object clause. Because this statement allows a user to impact the entire system, the permissions are implicitly ON PUBLIC.

You can specify any of the following privileges using the GRANT (Monitor Form) statement.

Option Description
ABORTSESSION Aborts any outstanding request or ongoing transaction of one or more Teradata Database sessions and, optionally, logs off the sessions.
MONRESOURCE Gathers information on the performance and availability of each PE and AMP.
MONSESSION Gathers information about logged on sessions and overall system usage on a session-by-session basis.
SETRESRATE Sets the frequency at which processor resource usage data is updated in the system.
SETSESSRATE Sets the frequency at which session-level performance data is updated in the system.

For information about revoking privileges granted by the Monitor form of GRANT, see REVOKE (Monitor Form).