Community
Products
Confluence
Questions
Fixing page permissions via database

Fixing page permissions via database

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

2 answers

1 accepted

1 vote

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Is this issue resolved ? How is the issue fixed ?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Product Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Get product advice from experts

Join a community group

Advance your career with learning paths

Earn badges and rewards

Connect and share ideas at events

Fixing page permissions via database

2 answers

1 accepted

Suggest an answer

Was this helpful?

Thanks!

TAGS

Atlassian Community Events