How to remove all restrictions from pages within a space
You'd like to switch to managing access to a space through global permissions and need to remove all the page level permissions
- Shutdown Confluence
- Backup your database
Run below query to find out the space id of the target space you want to remove the restrictions:
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Select SPACEID from SPACES WHERE SPACENAME = 'My Space Name';
The example spaceid is '851969', once you get the id from above query, replace the number 851969 in below queries and run then sequentially:
delete from CONTENT_PERM WHERE CPS_ID IN (select ID from CONTENT_PERM_SET WHERE CONTENT_ID IN (select CONTENTID from CONTENT WHERE SPACEID = 851969 AND CONTENTTYPE = 'PAGE'));
delete from CONTENT_PERM_SET WHERE CONTENT_ID IN (select CONTENTID from CONTENT WHERE SPACEID = 851969 AND CONTENTTYPE = 'PAGE');
- Start Confluence.
In case of any problems, please shutdown Confluence and restore the database by using the database backup taken from step 2.
Was this helpful?Yes Provide feedback about this article