XI's Oracle Plugins - what permissions?

[GldRush98]

I'll preface this by saying I am not a database guy. I know some MySQL, but even that is pretty limited, so forgive me if the answer to this is obvious.

I'm being asked what permissions the database user for the Oracle plugin requires? I told them that the query plugin will need select permissions on whatever table they're wanting to pull data from. Is that right? Are there additional permissions required?
If someone with some Oracle knowledge could fill me in here. They're wanting to only give me the absolute minimum permissions necessary, and I'm being asked exactly what I need and I don't really know what to tell them besides select on the tables they want monitored.
I'm also not sure what permissions the Serverspace and Tablespace plugins require.

[tgriep]

Try using these permissions for the Oracle database user account.
They should work for the Oracle Plugins.

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;
-- if usening 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;

[GldRush98]

Thank you for the information. I will pass this along

[tgriep]

Your welcome. If you don't have any more questions, shall I close and lock up the post?