Page is not editable due to page restrictions

Still need help?

The Atlassian Community is here for you.

Ask the community

Problem

Visiting the edit page URL manually with following URL:

http://<confluence-URL>/pages/editpage.action?pageId=PAGE_ID

 

Yields a "Not Permitted" page with "You are not permitted to perform this operation".

The page is not editable by anyone, including Confluence administrators. When viewing a Page's Restrictions, there may or may not be a restriction set for the page. The "Edit" menu is not visible anywhere on the page.

A flush of Confluence caches does not help.

Cause

There are no known problems with page restrictions, but it can be confusing to track them down.

Resolution

A space administrator can remove restrictions by visiting a combination of Browse >> Space Admin >> Permissions and Browse >> Space Admin >> Restricted Pages.

Note that Page Restrictions are inherited. Make sure to check for restrictions on parent pages as well.

Alternate Resolution

Always backup your data before performing any modifications to the database.

The information on page restrictions is stored in two tables, content_perm and content_perm_set. The first table stores content-level permissions objects, while the latter stores one-to-many mapping for content items and their permissions, with added metadata. For more information, please refer Confluence Data Model.

In this case, the content_perm_set table holds the mapping, however, the corresponding reference to the content_perm is missing. To find out more about this, identify the ID of the page:

SELECT * FROM content_perm WHERE cps_id in 
   (SELECT id FROM content_perm_set WHERE content_id in 
      (SELECT contentid FROM content WHERE title= '<PAGE_TITLE>' ORDER BY version DESC LIMIT 1));

Remove the row returned by the query:

DELETE FROM content_perm_set WHERE content_id in 
   (SELECT ID FROM content_perm WHERE cps_id in 
      (SELECT id FROM content_perm_set WHERE content_id in (SELECT contentid FROM content WHERE title= '<PAGE_TITLE>' ORDER BY version DESC LIMIT 1)));

(warning) The nested select statements are provided for clarity. Run each separately to understand more about the database structure.

Last modified on Feb 26, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.