Purpose

You'd like to switch to managing access to a space through global permissions and need to remove all the page level permissions

Solution

1. Shutdown Confluence
2. Backup your database

3. 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';

4. 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'));

5. And:

   delete from CONTENT_PERM_SET WHERE CONTENT_ID IN (select CONTENTID from CONTENT WHERE SPACEID = 851969 AND CONTENTTYPE = 'PAGE');

   
   

6. Start Confluence.