PostgreSQL Flexible Server should use managed identity

Medium Azure General postgres-managed-identity

Applies to

Microsoft.DBforPostgreSQL/flexibleServers

What CGPulse checks

A resource passes this rule when identity.type must be set. Anything else is reported as a finding with the evaluated property value attached as evidence.

How to fix it

Enable managed identity to eliminate stored credentials and improve security. In Azure Portal: PostgreSQL Flexible Server > Identity > enable System-assigned managed identity. See: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-identity

CLI

az resource update --ids "{id}" --set identity.type=SystemAssigned

Terraform

resource "azurerm_postgresql_flexible_server" "{name}" {
  name                = "{name}"
  resource_group_name = "{rg}"
  location            = var.location
  version             = "16"
  sku_name            = "B_Standard_B1ms"
  identity {
    type = "SystemAssigned"
  }
  # After enabling, grant the managed identity required RBAC roles
}

Compliance frameworks

Cloud Security BaselineIM-3

Vendor documentation

Is your environment compliant with this rule?

CGPulse checks it — and 621 others — against your Azure and AWS accounts with read-only access.

Run a free scan