-
Type:
Bug
-
Status: Resolved
-
Priority:
Normal
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: sqlserver
-
Labels:None
-
Template:customfield_10700 97205
-
Epic Link:
-
Team:Modules
The issue is found with PR: https://github.com/puppetlabs/puppetlabs-sqlserver/pull/147
Steps summary:
1. Successfully created 3 sqlserver login: ['Login1_7755', 'Login2_0966', 'Login3_4f0e']
2. Successfully created a server role that has the above 3 logins as its members by applying the below manifest:
sqlserver::config{'MSSQLSERVER':
|
admin_user => 'sa',
|
admin_pass => 'Pupp3t1@',
|
}
|
sqlserver::role{'ServerRole':
|
instance => 'MSSQLSERVER',
|
ensure => 'present',
|
role => 'Role_a0a4',
|
permissions => {'GRANT' => ['CREATE ENDPOINT', 'CREATE ANY DATABASE']},
|
type => 'SERVER',
|
members => ['Login1_7755', 'Login2_0966', 'Login3_4f0e'],
|
}
|
3. Attempted to drop the first two logins from the member list by applying below manifest:
sqlserver::config{'MSSQLSERVER':
|
admin_user => 'sa',
|
admin_pass => 'Pupp3t1@',
|
}
|
sqlserver::role{'ServerRole':
|
instance => 'MSSQLSERVER',
|
ensure => 'present',
|
role => 'Role_a0a4',
|
permissions => {'GRANT' => ['CREATE ENDPOINT', 'CREATE ANY DATABASE']},
|
type => 'SERVER',
|
members => ['Login3_4f0e'],
|
members_purge => true,
|
}
|
4. Expected behavior: role 'Role_a0a4' must have only 'Login3_4f0e' in member list
5. Actual behavior: The role still have all three member (screenshot attached)