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.
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.