Database administrators can set the privileges needed for users to monitor databases. Minimum privileges can be set or changed for existing and new users according to particular database requirements.

The following tables describe the minimum privileges that can be set for these databases:

MYSQL

PrivilegeDescriptionExample
SELECTMinimum privilege to monitor all G2 templatesGRANT SELECT ON *.* TO 'username'@'%';

MSSQL

PrivilegeDescriptionExample
serveradminMinimum privilege to monitor MSSQL DBsys.dm_exec_query_stats

ORACLEDB

PrivilegeDescriptionExample
CONNECTGive user connect role before assigning privileges.GRANT CONNECT TO MY_USER;
SELECT ANY DICTIONARYMinimum privilege to monitor all G2 templates.GRANT SELECT ANY DICTIONARY TO MY_USER;