OCI's Performance Hub causes authorization errors.
I enabled database management (basic management) for BaseDB in OCI using the DBSNMP user and checked the performance hub and got an error that I need to grant the appropriate permissions.
So once I ran GRANT SELECT ANY DICTIONARY TO DBSNMP; in CDB, the error went away.
However, in this case, the permissions that the DBSNMP user has by default should be sufficient for basic administration. (Ref: https://support.oracle.com/support/?anchorId=&kmContentId=null&page=sptemplate&sptemplate=km-article&documentId=KB57458)
With that in mind, I REVOKE the privileges granted by CDB.
I checked the performance hub again in that state (with the default privileges restored) and confirmed that it was working properly.
Tagged:
0