Auditing page permissions

We have a huge site with lots of pages and nesting. If you’ve ever used Sitefinity’s permission editor you can appreciate how absolutely painful it is to navigate that UI. It’s incredibly slow, and there’s absolutely no way you’re going through every. single. page.

So I came up with a quick SQL script to audit the custom page permissions. It’ll show you basically broken permissions, not inherited on every page… which is what you should be wanting, but you’ll also see the parent pages incase pages have the same name somewhere in the structure.

There’s one change you might need to make, and that’s to link it to sf_users instead of through sf_user_profile_link. I have it through there because we’re on Ldap and there’s nothing in sf_users, but every user has a profile so I can sneak out the nickname through that (nickname is the email).

So from here just call it into SQL, OR expose it through a ServiceStack service, or directly from backend code into a custom widget, it’s quite fast to execute.

Enjoy!