Database Grant Privilages
Posted: Wed Sep 30, 2015 9:19 am
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.
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.