How are you managing PostgreSQL / MSSQL (in Azure, if possible) users, roles, and grants with Pulumi?

For Azure, you would use the resources in the Azure Native provider (mssql, postgres). These are built from the Azure API spec, so they’re mostly equivalent to ARM templates. For users, roles, and such, you might need to use the Azure AD provider in addition.

I wonder how many people use those Azure native providers for Postgresql. They only offer you the ability to create databases and roles, nothing else. Also, the fact that the pulumi Postgres native provider does not allow importing, makes it difficult to manage dbs, users, roles, and grants with pulumi.

Yeah, I understand it’s incomplete. We’re limited by what the Azure API spec exposes (see here). Anything else we’d have to add manually, which we do occasionally with enough demand. What do you mean by importing in this context?

Yes, I know the main limitations come from Azure API. Regarding importing I mean that the native Pulumi PostgreSQL provider does not allow to import of existing databases, users, roles, or grants.

It does allow importing existing Databases. Any resource the Pulumi provider offers it should also be able to import. Not the other entities you mention, though.

For the import topic, I am talking about pulumi-postgresql, not about the Azure native provider.