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

sqlserver : Roles with the same name on multiple instances fails

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: sqlserver, windows
    • Labels:
    • Template:
      MODULES Bug Template
    • Acceptance Criteria:
      Hide

      The user should be able to manage two roles with the same name at the server level on two different instances on the same node.
      The user should be able to manage two roles with the same name at the database level on two different databases on the same instance.

      Neither of those two scenarios should result in duplicate sqlserver_tsql resource declarations in the role.pp or the permissions.pp defined type files.

      There should be unit testing and acceptance testing to cover these changes.

      Show
      The user should be able to manage two roles with the same name at the server level on two different instances on the same node. The user should be able to manage two roles with the same name at the database level on two different databases on the same instance. Neither of those two scenarios should result in duplicate sqlserver_tsql resource declarations in the role.pp or the permissions.pp defined type files. There should be unit testing and acceptance testing to cover these changes.
    • Team:
      Windows
    • Story Points:
      1
    • Sprint:
      Windows 2019-03-06
    • Method Found:
      Customer Feedback
    • QA Risk Assessment:
      Needs Assessment

      Description

      Basic Info
      Module Version: 2.3.0
      Puppet Version: N/A
      OS Name/Version: N/A

       

      When declaring `sqlserver_tsql` resources within the ./manifests/role.pp and the ./manifests/role/permissions.pp defined types, there was not enough information being inserted into the resource titles. This caused duplicate resource declarations if a user wanted to manage the same role on two different instances on a node, or on two different databases on the same instance. This caused issues for the following user scenarios:

      "I want to manage the members of the data_writer role on both instance 1 and instance 2".
      "I want to manage the members of the data_writer role on on database1 and database2 on the same instance".

       

      More details can be found in the PR: https://github.com/puppetlabs/puppetlabs-sqlserver/pull/293 

        Attachments

          Activity

            People

            Assignee:
            william.hurt William Hurt
            Reporter:
            dylan.ratcliffe Dylan Ratcliffe
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Zendesk Support