How to remove all restrictions from a specific page via the database
Purpose
If you'd like to remove page level permissions for a specific page via the database
Solution
- Shutdown Confluence
- Backup your database
Run below queries to replacing
page title and the spaceid
you'd like to have the permissions removed from:
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.
DELETE from CONTENT_PERM WHERE CPS_ID IN (select ID from CONTENT_PERM_SET WHERE CONTENT_ID IN (select CONTENTID from CONTENT where title='page title' and spaceid = 'spaceid where the page is housed'));
DELETE from CONTENT_PERM_SET WHERE CONTENT_ID IN (select CONTENTID from CONTENT WHERE title='page title' and spaceid = 'spaceid where the page is housed');
- Start Confluence
Last modified on Mar 21, 2024
Powered by Confluence and Scroll Viewport.