Page 1 of 1
required access rights on DBServers with Oracle and MSSQL
Posted: Wed Jul 11, 2012 11:20 am
by 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
Re: required access rights on DBServers with Oracle and MSSQ
Posted: Wed Jul 11, 2012 11:52 am
by 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
Re: required access rights on DBServers with Oracle and MSSQ
Posted: Thu Jul 12, 2012 3:09 am
by sikainfo
Thanks for the information
Regards Andy