Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Database Performance Analyzer (DPA) > Oracle permissions for DPA monitoring

Oracle permissions for DPA monitoring

Table of contents
Created by Interspire Import, last modified by Riggs Clough on Nov 15, 2016

Views: 291 Votes: 1 Revisions: 12

Overview

This article provides brief information on registering an Oracle database in SolarWinds DPA. 

You can use either of the following:

  • Existing user account 
  • Allow the DPA Wizard to create a new user

Environment

  • DPA version 9.0 or later
    • For versions previous, you may have to manually define the user rather than the &DPA_User
  • Ignite 4.3 or later

Detail

The following are the privileges required for the user: 

Execute these statements from the SYS user since it owns all X$ tables used by DPA:

 

This script assumes the DPA user has been created with no privileges and these commands add to it:

define Ignite_Username = &DPA_User

grant execute on sys.dbms_rowid

grant create table to &Ignite_Username;

grant create synonym to &Ignite_Username;

grant create session to &Ignite_Username;

grant create sequence to &Ignite_Username;

grant unlimited tablespace to &Ignite_Username;

grant select any dictionary to &Ignite_Username;

 

create or replace view x_$KSUSE as select * from x$ksuse;

 

create or replace view x_$ksusecst as select * from x$ksusecst;

create or replace view X_$KCCCF as select * from x$KCCCF;

create or replace view X_$KGLNA1 AS select * from x$kglna1;

create or replace view X_$KGLNA AS select * from x$KGLNA;

create or replace view x_$KGLCURSOR AS select * from x$KGLCURSOR;

create or replace view x_$dbgalertext AS select * from x$dbgalertext;

create or replace view x_$kcfio AS select * from x$kcfio;

create or replace view x_$kcftio AS select * from x$kcftio;

 

grant select on x_$ksuse to &Ignite_Username;

 

grant select on x_$ksusecst to &Ignite_Username;

grant select on x_$kcccf to &Ignite_Username;

grant select on x_$kglna1 to &Ignite_Username;

grant select on x_$kglcursor to &Ignite_Username;

grant select on x_$dbgalertext to &Ignite_Username;

grant select on x_$kcfio to &Ignite_Username;

grant select on x_$kcftio to &Ignite_Username;

grant select on v_$parameter to &Ignite_Username;

grant select on v_$instance to &Ignite_Username;

 

create or replace synonym &Ignite_Username..x$ksuse for sys.x_$ksuse;

 

create or replace synonym &Ignite_Username..x$ksusecst for sys.x_$ksusecst;

create or replace synonym &Ignite_Username..x$kcccf for sys.x_$kcccf;

create or replace synonym &Ignite_Username..x$kglna for sys.x_$kglna;

create or replace synonym &Ignite_Username..x$kglna1 for sys.x_$kglna1;

create or replace synonym &Ignite_Username..x$kglcursor for sys.x_$kglcursor;

create or replace synonym &Ignite_Username..x$dbgalertext for sys.x_$dbgalertext;

create or replace synonym &Ignite_Username..x$kcfio for sys.x_$kcfio;

create or replace synonym &Ignite_Username..x$kcftio for sys.x_$kcftio;

create or replace synonym &Ignite_Username..mproc for dual;

Last modified
14:20, 15 Nov 2016

Tags

Classifications

Public