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:
Alwaysyour 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.