While enabling Database Management for Base Database Service or Exadata Cloud
service, the database administrator can select from two options, Basic Management or
Full Management. For more information, see Enable Database Management.
Note
If you enable Database Management for Autonomous Database, you can access Performance Hub from the Database Management service also.
In Database Management, you can set preferred credentials for users so they
can automatically connect to the Managed Database and use Performance Hub.
Using Oracle Identity Cloud Service (IAM), you can create a policy that
grants users access to Performance Hub while limiting actions they can take
on the Oracle Database being analyzed. For more information, about
policies and how to use them, see How Policies Work.
The following example shows a policy that grants access only to performance
data without allowing general use access on Autonomous Databases.
Allow group <groupname>
to inspect autonomous-database-family in compartment <name>
Allow group <groupname>
to use autonomous-database-family in compartment <name>
where request.operation = 'RetrieveAutonomousDatabasePerformanceBulkData'