Specifying a SID value for SQL login creation

[acl-oss]

Use Case

Having the ability to specify a SID value when creating a login of type SQL_LOGIN, as this will allow us to ensure that SIDs match across all servers for logins of this type. This is required when cloning databases between environments for the permissions to be reflected

Describe the Solution You Would Like

A parameter for the sqlserver::login resource that allows you to specify the SID value directly

Describe Alternatives You've Considered

We are looking at conditionally creating anything of type SQL_LOGIN via a sqlserver_tsql resource and string interpolation, only using sqlserver::login for WINDOWS_LOGIN entries. This should work, but is pretty suboptimal!