Database Grant Privilages

[Mike]

Dear Team,

Which Grant privileges should be given to a new created user to monitor mssql,mysql, postgresql,oracle, mongodb.
As client is not ready to give the system administrator access user.

we had followed below steps which is mentioned in nagios forum..

The user account should have access to view all of the table/DB metrics listed in the wizard.

We would need a dB user with sql authentication created on each DB instance, set the "server role" permission to "public" and "user mapping" permission to "all databases in the instance dB reader permission" and also the user should have access to Sysperfinfo table


But still we are getting below error..
CRITICAL:Can access server but cannot query

please let us know if we are missing any grant privileges to give.

[lmiltchev]

Can you show us an example of the actual check run from the CLI that produced this error?