Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Database Performance Analyzer (DPA) > Oracle repository schema owner permissions

Oracle repository schema owner permissions

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 39 Votes: 0 Revisions: 9

The following permissions are granted to the Oracle schema owner when creating the DPA repository in an Oracle database. A new set of tables is created for each monitored database instance as noted at the bottom of the permission grants. The _x is replaced for each table with the ID associated with the ID column in the COND table. For example, the fifth instance registered gets assigned an ID of 5, so the corresponding SQL stats table in the schema of DPA is named CONSS_5.

 

create user Monitoring User
grant create synonym to Monitoring User
grant create procedure to Monitoring User
grant unlimited tablespace to Monitoring User
grant create table to Monitoring User
grant create session to Monitoring User
grant create sequence to Monitoring User
grant create view to Monitoring User
grant select_catalog_role to Monitoring User
grant select any dictionary to Monitoring User
Base Tables
Monitoring Tables (_x for each Monitored DB)

Last modified
19:16, 22 Jun 2016

Tags

Classifications

Public