Support for Microsoft Entra ID with Azure PostgreSQL - flexible server

[sschne]

What problem are you facing?

To be able to access an Azure PostgreSQL via Microsoft Entra ID ( either from an Entra ID User or Managed Identity ), we need to be able to create a user in PostgreSQL which is bound to said identity. See https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-configure-sign-in-azure-ad-authentication or https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-connect-with-managed-identity

How could Crossplane help solve your problem?

Crossplane to create a user in PostgreSQL which is bound to either Entra ID User or Managed Identity according to above documentation

[Duologic]

Can you provide some example SQL queries on how this would work?

[IvanJosipovic]

We are also looking for this, now that #166 is in progress, it might be easier to achieve.

Documentation for queries is here, https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-manage-azure-ad-users

[deggja]

We are also looking for this functionality. Would be very neat.

[chlunde]

Is this two parts: creating roles using this mode, and provider-sql authentication in this way, or just the role part?

Based on the queries in the documentation I don't think this would fit the existing role code but should be a different managed resource?