Question 296392 in Azure Question posted in
The official documentation to get you started can be found here.

azure postgresql database with azure entra id

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?

Tags:

2

Answers


  1. 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

    Login or Signup to reply.
  2. 0

    I was looking for the same problem and I’ve found this in GitHub issue. Seems to be related: https://github.com/MicrosoftDocs/azure-docs/issues/116898

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search