Page is not editable due to page restrictions
Visiting the edit page URL manually with following URL:
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.
There are no known problems with page restrictions, but it can be confusing to track them down.
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.
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)));
The nested select statements are provided for clarity. Run each separately to understand more about the database structure.