Table for page security

j October 1, 2015

I am looking for a T SQL method to get each pages security as it relates to groups and also users.  I am looking for how the data is set up in the database for confluence for pages, page security objects, groups and back to users.  I have users and groups tables understood.  I cannot identify how the pages and related security objects are working.

The available schema does not discuss this.

1 answer

0 votes
Ezra Rezky
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 3, 2016

Hi @jzurwell!

The table in the database which define the security of pages is the CONTENT_PERM table.

Check out this following screenshot of the content of CONTENT_PERM Table:
Click here to see Screenshot 

The table shows the restriction of who (user and/or group) can access the Contents (which include pages, comments, and attachments).

Hope my answer can help, and I wish you a good day!

Cheers,
Ezra A. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events