betr-io / terraform-provider-mssql

Terraform provider for Microsoft SQL Server
https://registry.terraform.io/providers/betr-io/mssql/latest
MIT License
35 stars 29 forks source link

The user is not added as a role member to the database #45

Open pyramidbuilder opened 1 year ago

pyramidbuilder commented 1 year ago

Dear Author,

I have used terraform to create a database user with specified roles. The user was created on the given database, but the roles defined in the roles array were not created What I did:

`resource "mssql_user" "my_user" { server { host = >hostname> login { username = password = } }

database = azurerm_mssql_database.sqldb.name default_schema = "dbo"

login_name = #it's important, because I don't want to add AD user. I guess a property missing here username = roles = [ "db_datareader", "db_datawriter" ]

depends_on = [ azurerm_mssql_database.sqldb ] }`

pyramidbuilder commented 1 year ago

Sorry, I saw that it was duplicated