Details
Description
The SQL Server module uses the IS_SRVROLEMEMBER function when modifying a user account, however if a WINDOWS_LOGIN for a user is disabled, IS_SRVROLEMEMBER always returns false. This means modifying a disabled account will fail.
The query login template instead uses the sys.server_role_members table to determine membership which is correct.
This ticket will modify the acceptance tests and templates to use the sys.server_role_members table instead of the IS_SRVROLEMEMBER function
Attachments
Issue Links
- links to