terraform-provider-mssql
terraform-provider-mssql copied to clipboard
feature request: sql contained auth and new db parameters
Hello,
I'm having some missing feature in current provider version when wanting to setup SQL users that use contained auth. Current "mssql_sql_user" resource can't do that and creating with script resource limits what you can do with that user.
So maybe you can please add additional parameters to "mssql_sql_user" resource for contained auth? Like password.
CREATE USER [<user_name>] WITH PASSWORD=N'<password>'
As well if we're talking about contained auth, maybe parameter in "mssql_database" to run alter database would be nice too like:
ALTER DATABASE [<database name>] SET CONTAINMENT = PARTIAL WITH NO_WAIT
or any other ALTER DATABASE.