Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

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

Oracle permissions for DPA monitoring

Table of contents
Created by Interspire Import, last modified by Jamin Walters on Apr 23, 2018

Views: 3,067 Votes: 1 Revisions: 13


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


  • 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


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 to &Ignite_Username;

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