Table for page security

j_qyagph

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.

Ezra Rezky

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.