how can i pull user permission for all users using sql or anyother way

[Anirudh Pratap Verma]

Hi,

We are on JIRA DC (9.4.18 version). How can I pull user permission for all users using SQL or any other way?

We want a view where if I select a user then I should be able to see

• which project he is added into

• what permissions does he have

• what all groups he is added into

Thanks,

[Trudy Claspill]

Hello @Anirudh Pratap Verma 

What you are asking for is actually extremely complex. Have you considered all the ways a user could have been added to a project, added to a group, and granted permissions?

• which project he is added into

A user can be "added to a project" in multiple ways:

1. explicitly as an individual to a role
2. explicitly added to a group that is added to a role
3. added to a group that is nested under another group that is added to a role

• what permissions does he have

A user can be allocated permissions in a project in multiple ways because permissions can be granted in multiple ways:

In the case of the Project Role and Group options above, the user could be a "member" directly or indirectly. With the use of everything from Reporter down you have to consider that the field values can change over time, so a user's permissions related to a specific issue in a project can also change over time.

• what all groups he is added into

Do you mean added to directly, or do you also want the ones to which the user is added indirectly by being a member of a group that is a member of a group?

Are you using only local groups, or are you integrated with an external Identity Provider like Active Directory?

-------------------

You may want to instead investigate one of the third party apps that helps with auditing user permissions. Here is a search from the Atlassian Marketplace to help you get started.

https://marketplace.atlassian.com/search?hosting=dataCenter&product=jira&query=user%20audit

[Anirudh Pratap Verma]

and this information is needed for all the users in jira.

[Martin Hilbig _GC Gruppe_]

if you want to get your data from the db directly, i'd start with the schema here: Database schema (atlassian.com)

you can alternatively see if your requirements can be satisfied using rest api endpoints: https://docs.atlassian.com/jira-software/REST/latest/