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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.