Unable to add UserAssignedIdentity on database as external user and grant db permission on mssql managed database

resource "mssql_user" "adduser" {
  server {
    host = hostname
    login {
      username = "xxxx"
      password = xxxxxx
    }
  }
  database  = "database"
  username  = dbuser
  object_id = dbpass
  roles               = ["db_datawriter", "db_datareader"]
}

UserAssigned Managed Identity has been added on MS SQL however we're unable to create and grant db access on data bases thru terraform

Error: │ Error: unable to create user [database].[hostname]: mssql: Incorrect syntax near 'type'.

We have been blocked from past 1 month, really appreciate any help on the issue.

When I ran SQL cmds on SSMS it worked but we would like to implement thru Terraform

CREATE USER [<managed-identity-name>] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [<managed-identity-name>];
ALTER ROLE db_datawriter ADD MEMBER [<managed-identity-name>];
ALTER ROLE db_ddladmin ADD MEMBER [<managed-identity-name>];
GO

betr-io / terraform-provider-mssql

Unable to add UserAssignedIdentity on database as external user and grant db permission on mssql managed database #60