Once you start having a large amount of databases, or more than one engineer on the team, management of your database users and their associated passwords can become a problem. It’s difficult to keep track of who has access and apply security policies consistently across all your databases.
Sign-in with Azure AD to Azure Database for PostgreSQL, using Azure Data Studio
Here is the quick version of how this works in Azure Data Studio - no password required!
Let's take a look in detail:
Configuring the Azure AD Administrator in the Azure Portal
We’ll start with a fresh Azure Database for PostgreSQL - Single Server database we just created and navigate to the Azure AD administrator view. There, we will set our own user account as the administrator:
Azure Portal: Configure Azure Active Directory administrator for your Azure Database for PostgreSQL server
Once the operation has completed, we can now sign-in with our user to the database: