16.20 - Monitor Privileges - 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

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).