Monitor Privileges| SQL Data Control Language | Teradata Vantage - 17.05 - Monitor Privileges - 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

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