Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > 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: 1,134 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

Tags

Classifications

Public