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.
Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot