Azure User Groups for OracleDB for Azure Database Resources

The Azure user groups discussed in this topic allow you to control user access to specific Oracle Database products in OracleDB for Azure. The Operations Covered information in each table details the level of access the Azure user group has for the specified resources. A user group with only "list " and "get" operations has read-only access to OracleDB for Azure resources displayed in the OracleDB for Azure portal. A user group with "create", "update", and "delete" operations can create, manage, and delete OracleDB for Azure resources.

OracleDB for Azure Database Family

The OracleDB for Azure Database Family groups are for users who need to either manage or view all OracleDB for Azure resource types. Users in this group can manage all resources in the following OracleDB for Azure products:

  • Oracle Exadata Database
  • Oracle Database on virtual machine DB systems
  • Autonomous Database
  • HeatWave
OracleDB for Azure Database Family Groups
Group Description Azure User Group Name Resource Types Operations Covered
OracleDB for Azure administrator (all database system types) odsa-db-family-administrators all create, list, get, update, delete
OracleDB for Azure read-only user (all database system types) odsa-db-family-readers all list, get

Exadata

The Exadata groups are for users who need to manage Exadata databases and infrastructure in OracleDB for Azure.

OracleDB for Azure Exadata Groups
Group Description Azure User Group Name Resource Types Operations Covered
Database infrastructure administrator odsa-exa-infra-administrators
  • cloud-exadata-infrastructures
  • cloud-vmclusters
  • db-nodes
create, list, get, update, delete
Database administrator odsa-exa-cdb-administrators
  • db-homes
  • databases
  • db-backups
create, list, get, update, delete
Database developer odsa-exa-pdb-administrators pluggable-databases create, list, get, update, delete

Autonomous Database

The Autonomous Database groups are for users who need to manage Autonomous Databases in OracleDB for Azure.

OracleDB for Azure Autonomous Database Groups
Group Description Azure User Group Name Resource Types Operations Covered
Database developer odsa-adbs-db-administrators
  • autonomous-databases
  • autonomous-database-backups
create, list, get, update, delete

Oracle Base Database (Virtual Machine DB Systems)

These groups are for users who need to manage Oracle Base Database databases and DB system infrastructure in OracleDB for Azure. Base Database systems can be provisioned on virtual machines in OracleDB for Azure.

OracleDB for Azure Base Database Groups
Group Description Azure User Group Name Resource Types Operations Covered
Database infrastructure administrator odsa-basedb-infra-administrators
  • db-systems
  • db-nodes
create, list, get, update, delete
Database administrator odsa-basedb-cdb-administrators
  • db-homes
  • databases
  • db-backups
create, list, get, update, delete
Database developer odsa-basedb-pdb-administrators pluggable-databases create, list, get, update, delete

MySQL HeatWave

Group Description Azure User Group Name Resource Types Operations Covered
MySQL Instances Administrator odsa-mysql-infra-administrators
  • mysql-instances
  • mysql-heatwave
  • mysql-configurations
  • mysql-backups
  • mysql-channels
create, list, get, update, delete
MySQL HeatWave Administrator odsa-mysql-heatwave-administrator
  • mysql-heatwave
create, list, get, update, delete