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)));

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

最終更新日: 2016 年 2 月 26 日

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

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.