Share via

PostgreSQL Entra Authentication via AD Group: get the personal user

Julian Gimbel 31 Reputation points Microsoft Employee
2024-08-02T07:48:16.05+00:00

I have users who sign in to PostgreSQL via an AAD group as described in the docs https://learn.microsoft.com/en-us/azure/postgresql/single-server/how-to-configure-sign-in-azure-ad-authentication#step-1-create-microsoft-entra-groups-in-azure-database-for-postgresql. I do not want to maintain the users individually in the database, but for the application I would need to know the actual AAD user which created the token, not only the group.
SELECT CURRENT_USER; and SELECT SESSION_USER; both only show the entra group.

Do you know if and how this is possible?

Thanks in advance

Azure Database for PostgreSQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 15,301 Reputation points
    2024-08-03T13:47:53.1533333+00:00

    Hi Julian Gimbel •,

    Welcome to Microsoft Q&A forum.

    As I understand, you want to PostgreSQL Entra Authentication via AD Group: get the personal user.

    As highlighted in the feedback channel, this feature is suggested and is not present at the moment.

    Please try to up-vote so that team can prioritize the same.

    Thanks

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.