To use Database Management for HeatWave and External MySQL, you must belong to a user group in your tenancy with the required permissions on the following Database Management resource-types:

• dbmgmt-managed-mysql-databases: This resource-type allows a user group to use the Database Management features to monitor HeatWave and External MySQL DB systems.
• dbmgmt-mysql-family: This aggregate resource-type includes the individual Database Management resource-types for HeatWave and External MySQL and allows a user group to enable and use Database Management.

Here are a few examples of the policies that grant user groups the permissions required to monitor HeatWave and External MySQL DB systems using Database Management:

• To grant the DB-MGMT-MYSQL-USER user group the permission to use all Database Management features for all the HeatWave and External MySQL DB systems in the tenancy:

  Allow group DB-MGMT-MYSQL-USER to manage dbmgmt-mysql-family in tenancy

• To grant the DB-MGMT-MYSQL-USER user group the permission to view the number of HeatWave and External MySQL DB systems for which Database Management is enabled (in compartment ABC) on the MySQL databases tile on the Database Management Overview page:

  Allow group DB-MGMT-MYSQL-USER to inspect dbmgmt-managed-mysql-databases in compartment ABC

• To grant the DB-MGMT-MYSQL-USER user group the permission to view the metrics and other details for a fleet of HeatWave and External MySQL DB systems and HeatWave clusters in compartment ABC:

  Allow group DB-MGMT-MYSQL-USER to read dbmgmt-managed-mysql-databases in compartment ABC

• To grant the DB-MGMT-MYSQL-USER user group the permission to view SQL performance data and configuration variables of a single HeatWave or External MySQL DB system in compartment ABC:

  Allow group DB-MGMT-MYSQL-USER to use dbmgmt-managed-mysql-databases in compartment ABC