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