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

sqlserver : Roles with the same name on multiple instances fails

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Normal
    • Resolution: Fixed
    • None
    • None
    • sqlserver, windows
    • 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.
    • Windows
    • 1
    • Windows 2019-03-06
    • Customer Feedback
    • 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

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

            Dates

              Created:
              Updated:
              Resolved:

              Zendesk Support