We are using jira for a while and the users love it. The growing numbers of users and projects we are using shows this. Unfortunately, as the set of persons and their roles as well as the permission schemes vary from one project to the other it has become a nightmare to find your way through it. Don't think it is getting easier by several persons sharing the administration work. On the contrary, there are various "handwritings".
Is their a convenient way to list up per user or per project who is entitled to do what?
Any helpful script, web-page or third party product would be appreciated.
While you have an ER diagram for jira, it is quite big to read and understand. The main tables you should be looking at are all tables starting with cwd_ , projectroleactor and projectrole. It is straight forward to derive the relationships.
Btw, per user there is already a page that shows the users roles, will that be helpful? (view project role link in the user page)
If you navigate to the People screen of your Project administration, you should see all users that are associated to each Project Role.
On the Permission screen on that same Project permission screen you should be able to see what are the permissions of each of those roles and users individually.
I'm not sure if you were thinking of a different to visualize that. Maybe directly on the database?
I'm not aware of any plugins that might display this differently.
Hope this helps,
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs