Is there a way to generate a list of pages a particular role has editor access to?

Michael Purgar asked on November 6, 2019 21:34

Hi everyone -

As the subject says, I'm looking for a way to generate a report that lists which published pages a particular role has been given the 'modify' access to. The long-term goal is to clean up what has become a complicated network of permissions, but short term I just need to see which pages Role X will be able to edit if a user gets that permission.

I've been hunting around the Admin for clues but turning up empty. Any ideas? Is there a table with the data I'm not finding? Any leads would be appreciated, thanks!

kentico 10 roles editing access

Correct Answer

Mike Wills answered on November 6, 2019 23:29

Hi Michael,

This is doable, but not easy. Have a look at Juraj's answer to this post. It will require creating a report based on CMS_Tree, CMS_ACL, CMS_ACLItem, and CMS_Role tables.

https://devnet.kentico.com/questions/need-to-list-what-roles-have-modify-permission-for-a-given-treenode-(sql-query)

Mike

0 votesVote for this answer Unmark Correct answer

Recent Answers

Michael Purgar answered on November 7, 2019 18:00

I still have a little work to do to polish up the query, but that does appear to be the information I need! I'm not sure what data I need from the CMS_ACL table though, I seem to be good making the connections without it. Otherwise it definitely puts me on the right track.

Thank you!

0 votesVote for this answer Mark as a Correct answer

Mike Wills answered on November 7, 2019 23:18

Good news. Thank you Michael!

0 votesVote for this answer Mark as a Correct answer