How are roles linked to pages in the database

lawrence whittemore asked on January 19, 2021 14:40

I'm trying to create a list of users who have access to a page by writing a sql query but am not sure where the links are happening. What columns are pages and roles linked on?

roles database

Correct Answer

David te Kloese answered on January 19, 2021 17:04

The default logic is on place in tree (so node not document)

So CMS_Tree table which has field NodeACLID

references CMS_ACL that is grouping rows in CMS_ACLItem

CMS_ACLItem contains the UserID or UserRole and if they are allowed or denied!

0 votesVote for this answer Unmark Correct answer

Recent Answers

lawrence whittemore answered on January 19, 2021 18:31

Thanks, would never have looked for ACL. What does ACL stand for?

0 votesVote for this answer Mark as a Correct answer

lawrence whittemore answered on January 19, 2021 18:38

Did some googling, my guess is that it is Access Control List.

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on January 19, 2021 19:36

There is a view View_CMS_ACLItem_ItemsAndOperators that will get you a lot of information but you'd have to dig into how that links into the CMS_Tree or CMS_Document table based on what David mentioned.

0 votesVote for this answer Mark as a Correct answer