Page 1 of 1

Oracle Database User Privileges for Nagios Monitoring

Posted: Thu Jul 16, 2020 8:43 am
by joseph.upshaw
When setting up the "Oracle Serverspace" via the Configuration Wizard, as expected, it is requiring a database username and password for the connection. Is there a document anywhere that list out the minimum privileges this user would need to perform the monitoring tasks?

We were planning to create a NAGIOS user just for this purpose but, we want to follow the least privilege principle.

Thanks,

-Joe

Re: Oracle Database User Privileges for Nagios Monitoring

Posted: Thu Jul 16, 2020 9:29 am
by joseph.upshaw
I think I found the answer to my own question here:

https://itgix.com/blog/post/oracle-data ... le-health/

CREATE USER nagios IDENTIFIED BY <PUT_PASSWORD_HERE> account unlock;
GRANT CREATE SESSION TO nagios;
GRANT SELECT any dictionary TO nagios;
GRANT SELECT ON V_$SYSSTAT TO nagios;
GRANT SELECT ON V_$INSTANCE TO nagios;
GRANT SELECT ON V_$LOG TO nagios;
GRANT SELECT ON SYS.DBA_DATA_FILES TO nagios;
GRANT SELECT ON SYS.DBA_FREE_SPACE TO nagios;