Prerrequisites

This plugin establishes remote connections to the databases it monitors, so it's essential to ensure connectivity between the Pandora FMS server and these databases.

In turn the following permissions are required for the user that is used to connect.

VIEW SERVER STATE:

To execute the SELECT @@VERSION query.
To query sys.dm_os_sys_info (server uptime).
To query sys.dm_exec_requests (active requests on the server).
To query @@MAX_CONNECTIONS (maximum connections allowed).
To run sp_who 'ACTIVE' (active sessions on the server).

SELECT:

To execute custom queries on specific database tables or views.