Azure / Azure/azure-postgresql
Azure AD Authentication in Postgres SQL
- Dominant language
- Bicep
- Stars
- 87
- Forks
- 81
- PR merge metrics
- No merged PRs in 30d
Description
Hello, I am trying to create an Azure AD role in postgres server with the pipeline. I login with the Azure AD Admin (configured in the ARM template). This Azure AD admin is a AAD group in the same tenant. However when I am trying to run the query CREATE ROLE "userID@tenant-domain.onmicrosoft.com" WITH LOGIN PASSWORD 'Azure Object ID' IN ROLE azure_ad_user
with pipeline , it throws below error. The same query when run through the Azure Data Studio with Azure AD admin login (same), works well. The pipeline service principal has the graph permissions too. Has anyone come across this kind of scenario in Postgres?
Please help. The goal is to create a Azure AD user through pipeline.

Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.