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,
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:
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
and this information is needed for all the users in jira.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.