Fixing page permissions via database

[volalex]

Hi, all!

How i can set and unset page permissions directly from database? It's needed because view our confluence page not permited for all users(Confluence Admins,System Admins etc...).

Confluence version is 4.2.8

[Bruna Griebeler · Accepted solution]

Hi Alexy,

In case you're familiar with database manipulation, you can refer to the SPACEPERMISSIONS table that stores all permissions from Confluence. Just be sure to create a database backup before changing anything.

Here's a page that might be of your interest: confluence.atlassian.com/display/DOC/Confluence+Data+Model

[Bob Swift OSS (Bob Swift Atlassian Apps)]

It would be safer to use something like addPermissions and removePermissions from Confluence Command Line Interface to do this type of thing.

[Anitha Parvatham]

Is this issue resolved ? How is the issue fixed ?