Grants system-wide performance monitoring privileges.
There is no lower level of MONITOR privilege: its scope is global. For example, the database administrator cannot grant user Addams the ability to do session-level monitoring of her applications only. Instead, the DBA must grant Addams the permission to do session-level monitoring of all applications by all sessions.
To determine who is using the MONITOR partition, issue the following query:
SELECT UserName, IFPNo FROM DBC.SessionInfoV WHERE partition = 'MONITOR';
The GRANT statement is used only to assign specific privileges.
To transfer ownership of a database or user, see GIVE.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
- MONITOR privileges to use the monitor form of GRANT
These privileges must be granted only to those users who are cleared to monitor all applications on all sessions.