Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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: 156 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