Monitor Privileges
GRANT MONITOR takes effect immediately when the grantee issues the next statement. The grantee does not need to log off and log back on to receive a newly granted monitor privilege.
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 Vantage 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).
Security Logging of Access Attempts
To maintain a security log of access attempts, see BEGIN LOGGING.