Oracle Wizard
Posted: Mon Nov 05, 2012 4:03 pm
What permissions does the user need to have that i will be using in the Oracle wizards?
Thanks!
Thanks!
Nagios Support Forum
Support for Nagios products and services
https://support.nagios.com/forum/
Oracle Wizard
Page 1 of 1
Re: Oracle Wizard
Posted: Mon Nov 05, 2012 4:09 pm
The user would need "Can (re)configure hosts and services." This will allow them to run a wizard without having access to the CCM. They can also configure add and delete their own services and hosts.
Re: Oracle Wizard
Posted: Mon Nov 05, 2012 4:12 pm
Sorry, you missunderstood my question, guess I didn't phrase it that great 
While running the Oracle wizard, it asks for a server IP and a username and password to connect to oracle with...what permissions does that Oracle user need?
While running the Oracle wizard, it asks for a server IP and a username and password to connect to oracle with...what permissions does that Oracle user need?
Re: Oracle Wizard
Posted: Mon Nov 05, 2012 5:47 pm
Ah sorry for the misunderstanding, the user is typically set up specifically for Nagios, and it's permissions would be based on what you are accessing. Usually read access but its all dependent on your needs.
Re: Oracle Wizard
Posted: Tue Nov 06, 2012 10:55 am
The underlying plugin suggests this:
Code: Select all
CREATE USER nagios IDENTIFIED BY oradbmon;
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;
-- or if you're using oracle 8.7.1 --
GRANT SELECT ON sys.dba_tablespaces TO nagios;
GRANT SELECT ON dba_temp_files TO nagios;
GRANT SELECT ON sys.v_$Temp_extent_pool TO nagios;
GRANT SELECT ON sys.v_$TEMP_SPACE_HEADER TO nagios;
GRANT SELECT ON sys.v_$session TO nagios;