Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

Unreleased

[0.3.1] - 2024-03-27

Added

Create login with SID. PR #74. Closes #64. Thanks to ValeruS for the PR.

Fixed

Support read timeout for SQL loop and better error handling. PR #61. Closese #25 and #57 with better error message. Thanks to Sebastien Coavoux for the PR.

[0.3.0] - 2023-12-29

Changed

Make minimum terraform version 1.5. Versions less than this are no longer supported (endoflife.date)
Upgraded to go version 1.21.
Upgraded dependencies.
Replaced github.com/denisenkom/go-mssqldb with github.com/microsoft/go-mssqldb.
Upgraded terraform dependencies.
Improve Makefile.

0.2.7 - 2022-12-16

Fixed

Fix concurrency issue on user create/update. PR #52. Closes #31. Thanks to Isabel Andrade for the PR.
Fix role reorder update issue. PR #53. Closes #46. Thanks to Paul Brittain for the PR.

0.2.6 - 2022-11-25

Added

Support two of the auth forms available through the new fedauth: ActiveDirectoryDefault and ActiveDirectoryManagedIdentity (because user-assigned identity) as these are the most useful variants. PR #42. Closes #30. Thanks to Bittrance for the PR.
Improve docs on managed identities. PR #39. Thanks to Alexander Guth for the PR.

0.2.5 - 2022-06-03

Added

Add SID as output attribute to the mssql_user resource. PR #36. Closes #35. Thanks to rjbell for the PR.

Changed

Treat password attribute of mssql_user as sensitive. Closes #37.
Fully qualify package name with Github repository. PR #38. Thanks to Ewan Noble for the PR.
Upgraded to go version 1.18
Upgraded dependencies.
Upgraded dependencies in test fixtures.

Fixed

Only get sql logins if user is not external. PR #33. Closes #32. Thanks to Alexander Guth for the PR.

0.2.4 - 2021-11-15

Thanks to Richard Lavey (PR #24).

Fixed

Race condition with String_Split causes failure (#23)

0.2.3 - 2021-09-16

Thanks to Matthis Holleville (PR #17), and bruno-motacardoso (PR #14).

Changed

Add string split function, which should allow the provider to work on SQL Server 2014 (#17).
Improved documentation (#14).

0.2.2 - 2021-08-24

Changed

Upgraded to go version 1.17.
Upgraded dependencies.
Upgraded dependencies in test fixtures.

0.2.1 - 2021-04-30

Thanks to Anders Båtstrand (PR #8, PR #9)

Changed

Upgrade go-mssqldb to support go version 1.16.

Fixed

Cannot create user because of conflicting collation. (#6)

0.2.0 - 2021-04-06

When it is not possible to give AD role: Directory Readers to the Sql Server Identity or an AD Group, use object_id to add external user.

Thanks to Brice Messeca (PR #1)

Added

Optional object_id attribute to mssql_user

0.1.1 - 2020-11-17

Update documentation and examples.

0.1.0 - 2020-11-17

Initial release.

Added

Resource mssql_login to manipulate logins to a SQL Server.
Resource mssql_user to manipulate users in a SQL Server database.