Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

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,055 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