Oracle Wizard

[BanditBBS]

What permissions does the user need to have that i will be using in the Oracle wizards?

Thanks!

[slansing]

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.

[BanditBBS]

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?

[slansing]

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.

[nscott]

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;