Create users from EntraID

[leinad87]

In Azure postgres (an probably other cloud instances) is it possible to add users managed by external auth providers. For example, we can add an user from EntraID (aka Active Directory) to Azure postges (doc]) using the following query:

select * from pgaadauth_create_principal('<identity_name>', false, false);

How could we do this with the provider? There is no option to run custom sql queries. Shall we update postgresql_role with an extra parameter?

[PvH-SPC]

Any update on this, been trying to find a way to at least run the SQL.. Keep in mind we need to authenticate the provider as an entra user, so my plan which is almost fully working is to have the ADO service account add itself as an admin, then use that account to authenticate and run the sql.

[PvH-SPC]

@leinad87 were you able to find a work around for this?

[leinad87]

@leinad87 were you able to find a work around for this?

No, the only option is to update the provider and add a resource to create principals. There should be no problem because there is an option to list them... I could do it, but there are 63 open PRs...