3 Replies Latest reply on Jun 28, 2013 4:28 AM by Heiko Rupp

    RHQ's Oracle plugin : which user privileges needed ?

    captain_mich Newbie

      Hi,

       

      I want to monitor an Oracle DB server but I don't want to use SYS or SYSTEM nor my JBoss datasource account.

       

      So I created a new user, but I don't want to grant him ALL PRIVILEGES.

      According to the Oracle rhq-plugin.xml, I granted SELECT ON DBA_USER and V_$SYSMETRIC (and CREATE SESSION ) to my user, but that wasn't enough.

       

      Then, I found in the org.rhq.plugins.oracle.OracleUserComponent source that V_$SESSION is needed too.

       

       

      Is it possible to create a role with only the SELECT ON needed, or have I to grant all DBA privileges ?

       

       

      Thanks.

       

      - RHQ 4.5.1

      - Oracle 10g

       

       

      Captain Mich.