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

This widget could not be displayed.

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
Community showcase
Posted Monday in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

268 views 2 4
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