Confluence user cannot move page in hierarchy

If a confluence user want to move a page in hierarchy, he always gets this forbidden icon. The page has no restrictions and the space permissions are set correctly.

dragdrop2.png

1 answer

1 accepted

Hi Bastian,

Somehow, the content permission sets for those master pages were empty (null). 

I have tested the solution to find all such pages and delete them with these SQL commands. I had H2 database, so you might want to adapt them for your DB of choice.

--select the pages within a space with empty permission set 
select c.contentid, c.title from content c, spaces s where c.spaceid = s.spaceid and s.spacekey = 'DECSM' and c.contentid in (select cps.content_id from CONTENT_PERM_SET cps left join CONTENT_PERM cp on cps.id = cp.cps_id where cps.cont_perm_type = 'Edit' and cp.id is null group by cps.id, cps.content_id)

--select the empty edit permission sets across all spaces 
select cps.content_id from CONTENT_PERM_SET cps left join CONTENT_PERM cp on cps.id = cp.cps_id where cps.cont_perm_type = 'Edit' and cp.id is null group by cps.id, cps.content_id 

--delete the content permission sets for affected pages in all spaces 
delete from content_perm_set where id in (select cps.id from CONTENT_PERM_SET cps left join CONTENT_PERM cp on cps.id = cp.cps_id where cps.cont_perm_type = 'Edit' and cp.id is null group by cps.id, cps.content_id)

After you execute the delete command, you have to flush Confluence cache (Admin -> Cache Management -> Flush All) in order to see changes. After that those pages should be moveable and will have a move button in the tools menu.

Cheers, 
Roman.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

2,925 views 27 12
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you