My Oracle Support Banner

[OCI DB]: Accessing Performance Hub Page Shows "Performance Hub requires granting of appropriate user privileges. After granting the required privileges, reopen Performance Hub" (Doc ID 2903792.1)

Last updated on NOVEMBER 08, 2022

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Getting the message below when trying to use Performance Hub in OCI console:

==================
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.