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

Add database constraints to prevent duplicate content permission entries

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.5.2
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                nbhawnani Niraj Bhawnani
                Reporter:
                nbhawnani Niraj Bhawnani
                Participants:
                Last Touched By:
                Katherine Yabut
                Reviewers:
                Richard Atkins
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Last commented:
                  8 years, 4 weeks, 2 days ago