Oracle Cloud Infrastructure Documentation

Individual Resource-Types

Use individual resource-types to control access to MySQL HeatWave Service resources.

mysql-instances

Use instance-specific policies of MySQL HeatWave Service to view and manage the DB systems.

Table 20-6 INSPECT

Permission APIs Fully Covered APIs Partially Covered

MYSQL_INSTANCE_INSPECT

ListConfigurations

ListDbSystems

ListReplicas

ListShapes

ListVersions

ListWorkRequests

 None

Table 20-7 READ

Permission APIs Fully Covered APIs Partially Covered

MYSQL_INSTANCE_READ

GetDbSystem

GetReplica

GetWorkRequest

 None

Table 20-8 USE

Permission APIs Fully Covered APIs Partially Covered

MYSQL_INSTANCE_USE

StopDbSystems

StartDbSystems

RestartDbSystems

CreateChannel

UpdateChannel

ResetChannel

ResumeChannel

DeleteChannel

MYSQL_INSTANCE_STOP

StopDbSystems

RestartDbSystems (also requires MYSQL_INSTANCE_START)

MYSQL_INSTANCE_START

StartDbSystems

RestartDbSystems (also requires MYSQL_INSTANCE_STOP

)

Table 20-9 MANAGE

Permission APIs Fully Covered APIs Partially Covered

MYSQL_INSTANCE_CREATE

CreateDbSystem (also requires COMPARTMENT_INSPECT, and MYSQL_CONFIGURATIONS_READ). If automatic backup is enabled, the following additional policies are required: MYSQL_BACKUP_CREATE and MYSQL_INSTANCE_CONTENT_READ

CreateReplica

 None

MYSQL_INSTANCE_DELETE

DeleteDbSystem

DeleteReplica

 None

MYSQL_INSTANCE_UPDATE

UpdateDbSystem

UpdateReplica

 None

MYSQL_INSTANCE_CONTENT_WRITE

RestoreBackup

CreateChannel

UpdateChannel

ResetChannel

DeleteChannel

MYSQL_INSTANCE_CONTENT_READ

DbSystemBackup

RestoreBackup

mysql-configurations

Use configuration-specific policies of MySQL HeatWave Service to view and manage the configurations.

Table 20-10 INSPECT

Permission APIs Fully Covered APIs Partially Covered
MYSQL_CONFIGURATIONS_INSPECT ListConfigurations None

Table 20-11 READ

Permission APIs Fully Covered APIs Partially Covered
MYSQL_CONFIGURATIONS_READ GetConfiguration CopyConfiguration (also requires MYSQL_CONFIGURATIONS_CREATE )

Table 20-12 USE

Permission APIs Fully Covered APIs Partially Covered
MYSQL_CONFIGURATIONS_UPDATE UpdateBackup None

Table 20-13 MANAGE

Permission APIs Fully Covered APIs Partially Covered
MYSQL_CONFIGURATIONS_CREATE CreateConfiguration CopyMysqlConfiguration (also requires MYSQL_CONFIGURATIONS_READ )
MYSQL_CONFIGURATIONS_DELETE DeleteConfiguration None

mysql-backups

Use backup-specific policies of MySQL HeatWave Service to view and manage the backups.

Table 20-14 INSPECT

Permission APIs Fully Covered APIs Partially Covered
MYSQL_BACKUP_INSPECT ListBackups DeleteBackup, RestoreBackup (also requires MYSQL_INSTANCE_CONTENT_READ and MYSQL_INSTANCE_CONTENT_WRITE)

Table 20-15 READ

Permission APIs Fully Covered APIs Partially Covered
MYSQL_BACKUP_READ GetBackup None

Table 20-16 USE

Permission APIs Fully Covered APIs Partially Covered
MYSQL_BACKUP_INSPECT RestoreBackup(also requires MYSQL_INSTANCE_CONTENT_READ, and MYSQL_INSTANCE_CONTENT_WRITE) None
MYSQL_BACKUP_UPDATE UpdateBackup None

Table 20-17 MANAGE

Permission APIs Fully Covered APIs Partially Covered
MYSQL_BACKUP_CREATE DbSystemBackup (also requires MYSQL_INSTANCE_CONTENT_READ) None
MYSQL_BACKUP_DELETE DeleteBackup (also requires MYSQL_BACKUP_INSPECT ) None
MYSQL_BACKUP_MOVE ChangeBackupCompartment None

mysql-channels

Use channel-specific policies of MySQL HeatWave Service to view and manage the replication channels.

Table 20-18 INSPECT

Permission APIs Fully Covered APIs Partially Covered

MYSQL_CHANNEL_INSPECT

ListChannels

 None

Table 20-19 READ

Permission APIs Fully Covered APIs Partially Covered

MYSQL_CHANNEL_READ

GetChannel

 None

Table 20-20 USE

Permission APIs Fully Covered APIs Partially Covered

MYSQL_CHANNEL_RESUME

ResumeChannel

 None

Table 20-21 MANAGE

Permission APIs Fully Covered APIs Partially Covered

MYSQL_CHANNEL_CREATE

CreateChannel

 None

MYSQL_CHANNEL_DELETE

DeleteChannel

 None

MYSQL_CHANNEL_UPDATE

UpdateChannel

 None

MYSQL_CHANNEL_RESET

ResetChannel

 None

mysql-heatwave

Use HeatWave-specific policies of MySQL HeatWave Service to view and manage HeatWave.

Table 20-22 READ

Permission APIs Fully Covered APIs Partially Covered

MYSQL_HEATWAVE_READ

GetHeatWaveCluster

 None

Table 20-23 USE

Permission APIs Fully Covered APIs Partially Covered
MYSQL_HEATWAVE_USE StartHeatWaveCluster None
MYSQL_HEATWAVE_STOP StopHeatWaveCluster RestartHeatWaveCluster (also requires MYSQL_HEATWAVE_START)
MYSQL_HEATWAVE_START StartHeatWaveCluster RestartHeatWaveCluster (also requires MYSQL_HEATWAVE_STOP)

Table 20-24 MANAGE

Permission APIs Fully Covered APIs Partially Covered
MYSQL_HEATWAVE_CREATE AddHeatWaveCluster None
MYSQL_HEATWAVE_DELETE DeleteHeatWaveCluster None

mysql-work-requests

Use work request-specific policies of MySQL HeatWave Service to manage the work requests.

Table 20-25 INSPECT

Permission APIs Fully Covered APIs Partially Covered
MYSQL_INSTANCE_WORK_REQUEST_INSPECT ListWorkRequests None

Table 20-26 READ

Permission APIs Fully Covered APIs Partially Covered
MYSQL_INSTANCE_WORK_REQUEST_READ GetWorkRequest None

Table 20-27 MANAGE

Permission APIs Fully Covered APIs Partially Covered
MYSQL_INSTANCE_WORK_REQUEST_DELETE DeleteWorkRequest None