Granting roles to user in Azure Synapse Dedicated Pool database

[owlleg6]

Hello!

Currently, it is not possible to grant role to user in Synapse dedicated database. Because, 'ALTER ROLE' is not working in such databases. Only

EXEC sp_addrolemember 'db_owner', 'User';

azure docs

Is there is any chance to provide some parameter in "mssql_user" resource, so when you are using Synapse dedicated pool database, it would be possible to switch to "EXEC" in part of Role assignment?

https://github.com/betr-io/terraform-provider-mssql/blob/9a2d23c1fd3086d90783eb3d07b145229738471e/sql/user.go#L157

Code snippet:

Error:

Cheers, Oleh.