Confluence user cannot move page in hierarchy

[Deleted user]

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

[roman · Accepted solution]

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.