Hi Toby - excellent job but just trying to understand few thing - I can see that permissions on Workbook/View level are showing good but on Project level it's kind of showing differently e.g, if I have a User or Group assigned Publisher "capability" - this view shows View & Write in Capabilities sections instead of Publish - i manually tried to map Project id with next_gen_permissions but getting same result.
is there any other table which contains Project level Role info?
thanks a lot for your help
Syed, I haven't looked at this for months and I'm pretty sure how permissions are stored/handled in the db has changed since. I don't know. Sorry, not the news you want to hear
But we’re still using server 10.0 and I was hoping this will work in that.
Keeping my fingers crossed to see if anyone else have such a need and using such a workbook.
We need to create an Audit workbook in which we want to proactively findout if any Group is assigned Publisher Role/access on any project to avoid accidental permissions.
I'm on 10.3 and this still works perfectly. Thank you for putting this together.