Submit a ticketCall us

AnnouncementUpgrading SolarWinds Orion Platform products has never been easier!

The SolarWinds Orion Installer is an all-in-one application for installations and upgrades. You use one installer to install or upgrade multiple Orion Platform products and install or upgrade Additional Polling Engines, Additional Web Servers, and High Availability Servers.

Learn more in the SolarWinds Orion Installer.

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,384 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