Setting page restrictions via SQL

[Balazs Hornyak]

I've got a task to remove all edit permissions from restricted pages. I've found the 2 table that contains that data, the CONTENT_PERM, and CONTENT_PERM_SET.

I've tried to change the CONT_PERM_TYPE (CONTENT_PERM_SET table) from Edit to View but I've noticed no change in the permission. Then I set the CP_TYPE (CONTENT_PERM table) to View as well but no luck.

Do I need to reindex/restart or do anything to commit the changes?

Will that cause an issue if there are 2 CPS_ID containing View (one is the old Edit and one is the regular View, will those 2 merge or should I do that manually?

Should I set both to View or is one of them enough?

What Am I doing wrong?

Thanks.

[Rilwan Ahmed]

Hi @Balazs Hornyak ,

Always backup your database and test the SQLs in test/staging confluence. 
Before running any SQLs, please stop confluence, run the SQLs and then start the confluence. 
Reindexing is always good as there are modifications to multiple items in the backend. 

Regarding the tables, I strongly suggest please contact the Atlassian support with your SQLs in https://support.atlassian.com/contact/#/

Support team will analyze and get back to you with right steps.