terraform-provider-mssql icon indicating copy to clipboard operation
terraform-provider-mssql copied to clipboard

feature request: sql contained auth and new db parameters

Open Krad-dono opened this issue 2 years ago • 1 comments

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.

Krad-dono avatar Jan 03 '23 08:01 Krad-dono