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?

terraform-provider-mssql/sql/user.go

Line 157 in 9a2d23c

' SET @sql = ''ALTER ROLE '' + QuoteName(@role) + '' ADD MEMBER ' + QuoteName(@username) + ''';' +

Code snippet:

Error:

Cheers,
Oleh.