How to get an overview of current users, their groups, and resulting project roles and permissions?

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.

3 answers

1 accepted

I tried to install it, nothing happend. I had no additional graphics on the screen, nor additional menu items. Is the version 2 supposed to work with Jira 4.4 at all? if not, where can I get version 1.

You should get version 1.0.5 (this is for JIRA 4.4), not 2.x (JIRA 5.x)

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)

0 votes

Hi Armin,

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,


If there is some documentation somwhere how things are stored in the database, i could extract that info and maybe build some clever queries. (is there?)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,472 views 15 19
Read article

Atlassian User Groups

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!

Find my local user group

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

Groups near you