Submit a ticketCall us

Cloud Workloads: Meet Your New Hybrid IT Reality
Have you found yourself in that evolving, hybrid IT grey area and wondering if cloud workloads are now part of your purview? And if so, will monitoring cloud workloads require a new set of dedicated cloud monitoring tools? Your answers: yes, they should be, and no, they don’t.

Find out how SolarWinds® Server & Application Monitor (SAM) can help you monitor your cloud workloads side by side with your on-premises workloads. Register Now.

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