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

Restricted blog posts are not listed in the Restricted Pages list

    XMLWordPrintable

    Details

      Description

      Summary

      Restricted blog posts are not listed in the Restricted Pages list and cannot be seen by Confluence Administrators. This is against the description in the documentation,

      Space Administrator should be able to view the list of restricted pages in a space

      Steps to Reproduce

      1. Create a new space
      2. Create a blog in this space
      3. Restrict this blog post to yourself
      4. Log in as Confluence Administrator user
      5. Go to the space > Space Tools > Permissions > Restricted Pages

      Expected Results

      1. All the restricted pages are displayed in the list

      Actual Results

      The blog post is not listed there

      Notes

      Any restricted normal pages will be listed there

      Comment from customer:

      On restricted pages the space/confluence admin is able to display the restricted pages in space administration -> permissions -> restricted pages
      This is not possible for blog posts.
      Our internal controlling MUST be able to at least be aware that there are blog posts not visible to them. This is not possible by now (5.7.3)

      Workaround

      1. Use the following SQL query to find out any blog post that has a "View" restriction set in the space level:

      SELECT
      s.SPACENAME,
      s.SPACEID,
      c.CONTENTID,
      c.CONTENTTYPE,
      c.TITLE,
      o.CONT_PERM_TYPE
      
      FROM
      SPACES s
      LEFT JOIN CONTENT c
      
      ON
      s.SPACEID = c.SPACEID
      LEFT JOIN CONTENT_PERM_SET o
      
      ON
      c.CONTENTID = o.CONTENT_ID
      WHERE c.CONTENTTYPE = 'BLOGPOST'
      AND CONT_PERM_TYPE = 'View'
      AND s.SPACENAME = '<name of space>'
      ORDER BY 2 DESC, 1 ASC;
      

      Take note of the "contentID" shown in the SQL result. Using Admin rights, access this page by its URL:

      <base_URL>/pages/viewpage.action?pageId=<contentID obtained>
      

      2. Disable normal users to restrict all contents in the space level:
      Go to Space Tools > Permission > Remove the "Add/Delete" Restriction rights from normal users

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                rs1 Jan-Peter Rusch
                Participants:
                Last Touched By:
                Katherine Yabut
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

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