Uploaded image for project: 'Modules'
  1. Modules
  2. MODULES-2543

sqlserver::role members_purge doesn't drop members

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: sqlserver
    • Labels:
      None
    • Template:
    • Team:
      Modules

      Description

      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)

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            phong Phong Ly
            QA Contact:
            Phong Ly
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Zendesk Support