azure postgresql database with azure entra id

Question

I am going through below documentation which shows various ways to authenticate Azure PostgreSQL database with Azure Entra ID

https://learn.microsoft.com/en-us/azure/postgresql/single-server/how-to-configure-sign-in-azure-ad-authentication#creating-microsoft-entra-users-in-azure-database-for-postgresql

In section named "Creating Microsoft Entra users in Azure Database for PostgreSQL" it suggest to run below command but I am getting an error that "azure_ad_user" does not exists.

CREATE USER "[email protected]" IN ROLE azure_ad_user;

Am I missing something? Is this group is supposed to be there or am I supposed to create this group?

Answer 1

You can use the code below to add Entra ID authentication to your PostgreSQL database:

CREATE USER "<EntraId>" WITH LOGIN;

This will add Entra ID login to the PostgreSQL database. Alternatively, you can add it via the portal by following this procedure: Go to Authentication, click on Add Microsoft Entra Admin, and select Entra ID as shown below:

Answer 2

I was looking for the same problem and I've found this in GitHub issue. Seems to be related, someone from Microsoft is investigating it (no solution yet as of 1st December 2023): https://github.com/MicrosoftDocs/azure-docs/issues/116898