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?

Have you already enabled Entra admin on the DB as described here? learn.microsoft.com/en-us/azure/postgresql/single-server/…. Then have you logged in with the Entra admin using the token as described here "learn.microsoft.com/en-us/azure/postgresql/single-server/…" ? If you have followed the steps correctly, you do not need to create a separate role for azure_ad_user. It should already be there. — Anupam Chand
– Anupam Chand, Commented Nov 9, 2023 at 3:40
@AnupamChand I am using "Azure Database for PostgreSQL flexible server" and I don't see the option. Is there a different way to set this for flexible server? — Ravi Khambhati
– Ravi Khambhati, Commented Nov 13, 2023 at 14:09

Bhavani · Accepted Answer · 2023-11-09 07:36:11Z

0

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

CREATE USER "<EntraId>" WITH LOGIN;

enter image description here

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:

enter image description here

answered Nov 9, 2023 at 7:36

Bhavani

5,4762 gold badges6 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ravi Khambhati Over a year ago

The admin account is already added.

Bhavani Over a year ago

Did you try with CREATE USER "<EntraId>" WITH LOGIN with admin account have you got any issue?

Jonathan · Accepted Answer · 2023-12-01 16:49:31Z

-1

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

edited Dec 1, 2023 at 16:49

answered Dec 1, 2023 at 13:13

Jonathan

11 bronze badge

Collectives™ on Stack Overflow

azure postgresql database with azure entra id

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related