My Oracle Support Banner

OCI Database Management Service : Accessing Perfomance Hub Reports Grants Error (Doc ID 2979248.1)

Last updated on MAY 08, 2024

Applies to:

OCI Database Management Service - Version NA and later
Information in this document applies to any platform.

Symptoms

Below messages are showing  on  OCI Database Management Performance Hub page Even though all the required privileges have been already granted to monitoring user.


Performance Hub requires granting of appropriate user privileges. After granting the required privileges, reopen Performance Hub.
---
GRANT CREATE PROCEDURE to <db_monitoring_user>
GRANT SELECT ANY DICTIONARY, SELECT_CATALOG_ROLE to <db_monitoring_user>
GRANT ALTER SYSTEM to <db_monitoring_user>
GRANT ADVISOR to <db_monitoring_user>
GRANT EXECUTE ON DBMS_WORKLOAD_REPOSITORY to <db_monitoring_user>

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.