How to remove all restrictions from pages within a space
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
You'd like to switch to managing access to a space through global permissions and need to remove all the page level permissions
Solution
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 making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
1
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:
1
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'));
And:
1
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?