Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-22123

Add database constraints to prevent duplicate content permission entries

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Low Low
    • 3.5.2
    • None
    • None
    • None

      Add a database constraint to prevent duplicate content permission entries (i.e. entries with the same user or group against the same content with the same permission level)

      An upgrade task is also needed that will clean up any existing duplicate entries and then add the constraint.

      Also need to ensure that XML imports from backups that contain duplicate permission entries report useful errors or are handled silently.

      Attached is a patch that adds the constraint but does not do any special handling for XML imports with duplicate permissions.

            [CONFSERVER-22123] Add database constraints to prevent duplicate content permission entries

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2887079 ] New: CONFSERVER Bug Workflow v4 [ 2998931 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2795141 ] New: JAC Bug Workflow v3 [ 2887079 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2733549 ] New: JAC Bug Workflow v2 [ 2795141 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2398931 ] New: JAC Bug Workflow [ 2733549 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2297114 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2398931 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2232556 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2297114 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2192845 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2232556 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1932094 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2192845 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1732082 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1932094 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1687627 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1732082 ]

              nbhawnani Niraj Bhawnani
              nbhawnani Niraj Bhawnani
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: