required access rights on DBServers with Oracle and MSSQL

[sikainfo]

Hi there,
can someone tell me what minimal access rights for MS-SQL server and Oracle Server Plugins are required on the database servers ?
Thanks

[nscott]

For Oracle, this should get you going:

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;
--
---For Oracle 8.1.7
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;

For MSSQL, it depends on server type, but you'll need to do something along the lines of the following, assuming a `nagios` user

Code: Select all

GRANT SELECT ON sys.sysperfinfo TO nagios
GRANT VIEW SERVER STATE TO nagios

[sikainfo]

Thanks for the information

Regards Andy