nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

List of page restrictions from DB

Evgeny Boytsov

Grettings ! I need to get a list of users who have restrictions on accessing the pages in confluence by querying the database. what table does this data contain?

Accepted answers

Davin Studer

The table you are looking for is called CONTENT_PERM.

Column name  | Description
----------------------------------------------------
ID           | table primary key
CP_TYPE      | type of page restriction (View or Edit)
USERNAME     | foreign key to the user_mapping table either this or GROUPNAME will be set
GROUPNAME    | either this or USERNAME will be set
CPS_ID       | foreign key to the CONTENT table
CREATOR      | foreign key to the user_mapping table
CREATIONDATE | creation date
LASTMODIFIER | foreign key to the user_mapping table
LASTMODDATE  | last modification date

All comments

Mirek

Hmm.. why using DB? You can list all restrictions by going to Space Admin > Restricted Pages on each space that you are interested in.

Tinker Fadoua

Hi Theyoba,

Here is the link the the Confluence DB.

I don't see permissions based on pages, it is more space level.

Space Group Permissions
Space permissions

We have to get space admins used to grant access to pages by group and not by individuals. I am fighting for it right now in my company

Davin Studer

The table you are looking for is called CONTENT_PERM.

Column name  | Description
----------------------------------------------------
ID           | table primary key
CP_TYPE      | type of page restriction (View or Edit)
USERNAME     | foreign key to the user_mapping table either this or GROUPNAME will be set
GROUPNAME    | either this or USERNAME will be set
CPS_ID       | foreign key to the CONTENT table
CREATOR      | foreign key to the user_mapping table
CREATIONDATE | creation date
LASTMODIFIER | foreign key to the user_mapping table
LASTMODDATE  | last modification date

Tinker Fadoua

User will need to use a join with another table so that he can get the username. Username in CONTENT_PERM table displays as numbers

It shows the group name but not individuals.

Evgeny Boytsov

Thank you very much ! One more question, please.

How i can join it to normal view.

GROUPNAME | USER

Is ID`s in table = ID`s in table cwd_user ?

Davin Studer

In the above answer I put in the description section the tables that the foreign keys map to.

Evgeny Boytsov

@Davin Studer thank a lot ! I did it !

Cinnober Admins

If you are looking for a particular users' restricted pages -

select * from CONTENT where CONTENTID in ( select CONTENT_ID from CONTENT_PERM_SET where ID in (select CPS_ID from CONTENT_PERM where USERNAME in (select user_key from user_mapping where lower_username like "lower.username")));

Joel Andrews

I am looking for a way to list ALL restricted pages in ALL spaces in order to understand what we have to possibly add in an admin group to fix any broken macros post-migration in those restricted pages.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

database