There is a KB article that has a basic query that you can use as a starting point here. This will list Project Permissions for a Group or User. As Nic said, it is not comphrensive in terms of what users can and cannot do throughout the entire Project, but t will tell you what Project Permissions are being used:
Also, for reference: https://confluence.atlassian.com/jira/managing-project-permissions-185729636.html
There is not a simple way to do this. As a member of a group, I could have a project permission granted to me because:
Bascially, you'll need to write a whole load of queries and merge the results. May I ask what the overall goal is here?
That's a very complex task you've set yourself. The SQL for getting it out as a single query is far too complex and includes the need to parse xml while you're at it if you want a proper accurate answer to "who can do what in my project". I'd go back to your users and ask why they need this and tell them that it's a small project that they're going to have to fund if they want it.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG