[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 laterInformation 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 |