System assigned managed identity in Azure Database for PostgreSQL flexible server

Use the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

2. In the resource menu, under the Security section, select Identity.

   

3. In the System assigned managed identity section, select On.

   

4. Select Save.

   

5. If the server has data encryption configured to use customer managed keys, you can't disable the system assigned managed identity of the server after you enable it. For that reason, if the portal detects this condition, it asks you to confirm that you want to enable the system assigned managed identity.

   

6. When the process starts, a notification informs you that the system assigned managed identity is being enabled.

   

7. When the process finishes, a notification informs you that the system assigned managed identity is enabled.

   

Use the az rest command to directly invoke the Servers - Update REST API.

# Enable system assigned managed identity
subscriptionId=<subscription-id>
resourceGroup=<resource-group>
server=<server>
result=$(az postgres flexible-server show --resource-group $resourceGroup --name $server --query "identity.type" --output tsv)
if [ -z "$result" ]; then
    az rest --method patch --url https://management.chinacloudapi.cn/subscriptions/$subscriptionId/resourceGroups/$resourceGroup/providers/Microsoft.DBforPostgreSQL/flexibleServers/$server?api-version=2024-08-01 --body '{"identity":{"type":"SystemAssigned"}}'
elif [ "$result" == "UserAssigned" ]; then
    az rest --method patch --url https://management.chinacloudapi.cn/subscriptions/$subscriptionId/resourceGroups/$resourceGroup/providers/Microsoft.DBforPostgreSQL/flexibleServers/$server?api-version=2024-08-01 --body '{"identity":{"type":"SystemAssigned,UserAssigned"}}'
else
    echo "System Assigned Managed identity is already enabled."
fi

Use the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

2. In the resource menu, under the Security section, select Identity.

   

3. In the System assigned managed identity section, select Off.

   

4. Select Save.

   

5. When the process starts, a notification informs you that the system assigned managed identity is being disabled.

   

6. When the process finishes, a notification informs you that the system assigned managed identity is disabled.

   

Use the az rest command to directly invoke the Servers - Update REST API.

# Disable system assigned managed identity
subscriptionId=<subscription-id>
resourceGroup=<resource-group>
server=<server>
result=$(az postgres flexible-server show --resource-group $resourceGroup --name $server --query "identity.type" --output tsv)
if [ "$result" == "SystemAssigned" ]; then
    az rest --method patch --url https://management.chinacloudapi.cn/subscriptions/$subscriptionId/resourceGroups/$resourceGroup/providers/Microsoft.DBforPostgreSQL/flexibleServers/$server?api-version=2024-08-01 --body '{"identity":{"type":"None"}}'
elif [ "$result" == "SystemAssigned,UserAssigned" ]; then
    echo "System Assigned Managed identity cannot be disabled as the server has User Assigned Managed identities assigned."
else
    echo "System Assigned Managed identity is already disabled."
fi

Use the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

2. In the resource menu, select Overview.

   

3. Select JSON View.

   

4. In the Resource JSON panel that opens, find the identity property. Inside it, you can find the principalId and tenantId for the system assigned managed identity.

   

# Show the system assigned managed identity
resourceGroup=<resource-group>
server=<server>
az postgres flexible-server identity list \
  --resource-group $resourceGroup \
  --server-name $server \
  --query "{principalId:principalId, tenantId:tenantId}" \
  --output table

Use the Azure portal:

1. Locate the Enterprise Applications service in the portal, if you don't have it open. One way to do it is by typing its name in the search bar. When the service with the matching name is shown, select it.

   

2. Choose Application Type == Managed Identity.

3. Provide the name of your Azure Database for PostgreSQL flexible server in the Search by application name or object ID text box.

   

# Verify the system assigned managed identity
server=<server>
az ad sp list --display-name $server