# Page is not editable due to page restrictions

#### お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

## 問題

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.

## 原因

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.

## Alternate Resolution

データベースを変更する前には必ずデータをバックアップするようにします。

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.

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する