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