In this video of Azure AD expert Andrey Chudnovskiy’s talk at Citus Con: An Event for Postgres, learn about the security benefits of Azure AD authentication compared to password-based methods. This talk covers the process of managing PostgreSQL roles in the Azure Database for PostgreSQL managed service-for Azure AD Users, Groups, and Applications, as well as the process of obtaining tokens and connecting to PostgreSQL in different environments.
Andrey explains how Azure AD authentication works in Flexible Server in Azure Database for PostgreSQL-plus how to use Azure AD to provide a secure and convenient way to authenticate users/applications connecting to PostgreSQL databases.
Andrey Chudnovskiy is a Principal Software Engineering Manager @Microsoft leading Azure AD integration for the Postgres managed service on Azure, Azure Database for PostgreSQL, with a specific focus on the Flexible Server option. Andrey joined the PostgreSQL database world 3 years ago, after a decade of experience building applications and systems at both Microsoft and Google.
► Video bookmarks:
⏩ 00:00 Introduction
⏩ 02:12 What is Azure AD & how does it work with Flexible Server?
⏩ 06:45 Connect to Azure AD with Flexible Server
⏩ 12:37 Connect as Application & Impersonate as User
⏩ 20:02 Use Azure AD Groups & Advanced roles
✅ Learn more:
Watch more Citus Con talks: aka.ms/citusco...
📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: aka.ms/cituscon
📌 Let’s connect:  
Twitter - @CitusCon, / cituscon
More resources:
📣 Slides for Andrey’s Azure AD authentication talk: aka.ms/citusco...
#CitusCon #PostgreSQL #Azure