Azure Postgres AD Authentication

Raj Patrao 21 Reputation points
2020-11-16T18:27:59.463+00:00

We are looking at having multiple databases in a Single Server setting on Azure Database for Postgres SQL.
40211-postgres.png

Per documentation

  • Customers can manage database permissions using external (Azure AD) groups.
  • Azure AD authentication uses PostgreSQL database roles to authenticate identities at the database level
  • Support of token-based authentication for applications connecting to Azure Database for PostgreSQL

Has anyone tried doing this i.e. databaseA and databaseB with permission to ADGroupA and ADGroupB respectively, under single Azure DB server instance ? Does this give complete data isolation between the different databaseA and databaseB ?

Azure Database for PostgreSQL
0 comments
Accepted answer
  1. KalyanChanumolu-MSFT 8,316 Reputation points
    2020-11-18T12:40:14.307+00:00

    @RajeshLawrencePatrao-2057 Welcome to Microsoft Q&A forums.

    Yes, you can use 2 separate AD groups on 2 different databases for access control on a single server.

    If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest