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?
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!
Thanks, would never have looked for ACL. What does ACL stand for?
Did some googling, my guess is that it is Access Control List.
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.
Please, sign in to be able to submit a new answer.