Azure / Azure/azure-postgresql

Azure AD Authentication in Postgres SQL

Open
#81 0 comments 1 reaction 0 assignees View on GitHub
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.

![image](https://user-images.githubusercontent.com/28840799/85789349-ac269180-b6eb-11ea-9849-681989478c4a.png)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.