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

null CREATOR inserted in CONTENT_PERM

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Not a bug
    • None
    • None
    • None
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? See the corresponding suggestion.

      The creator column in the CONTENT_PERM should not be null unless the user that caused that record to be added was really anonymous.

      For reference see:
      https://support.atlassian.com/browse/CSP-95615
      https://answers.atlassian.com/questions/133543/space-admin-page-restrictions-creator-shows-as-anonymous-when-it-isn-t-bug

      To confirm, Adrien Ragot (Atlassian) in answers confirmed it was a bug:

      "I have just noticed a small bug: When you use the Restrictions dialog to add several groups, the first group always appears in CONTENT_PERM with CREATOR = NULL and all the other groups have a value in CREATOR."

      Bruna Griebeler (Atlassian) also mentioned was a bug when she said in the support ticket:

      "As we talked yesterday, this is the query to set the creator as the lastmodifier user, to avoid let the creator as null, for security reasons.

      update CONTENT_PERM set CREATOR=LASTMODIFIER where creator=NULL;

      PS: Please create a backup of your database before running that query!!
      About the bug itself, I'll talk with a developer and will let you know as soon as possible."

      In the support ticket, the customer indicated that they would like to see a resolution that does not involve having to run a SQL update frequently.

      Without a customer workaround, this bug basically disables the ability for the space administrator to audit changes properly.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              2e8177f73f93 Gary Weaver
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: