How to select Issues from Database based on Permissions


I am looking to have a possibility to access the Jira Issues straight from Database for data mining but based on the permissions set on projects.

I would like to be sure that during that process the issues with the Private or Special Permissions will not be selects.



1 answer

0 votes

That can get very complex - you'll need to duplicate all the processes in Jira that handle the visibility of an issue by user.

For the most simple system, you'll need to look up the user's groups, then their roles in each project, then the permission schemes for each and every project and then you'll at least be able to see if they have "browse" in a project. From memory, there's 9 tables to be joined and/or queried.

In a more complex system, you'll also need to start reading for the issue security scheme, which could lead you to another 6 or 7 tables.

You will probably find it a LOT easier to do this by using Jira itself, or pulling queries over REST, because a) Jira will do the code for you and b) you'll never have to worry that your interpretation of the rules is different from Jira's

I know that it will be easier to do that throught the REST interface but the product that we are using to collect the data from different systems can access to Database only and not external interfaces.

It will be very useful if you can point to the specific tables to look for data as I am already couple of days digging for that with very small effort :(

Ugh. Well, you'll need all the tables with "permissions" in the name. Then the CWD tables if you're using Jira's internal users for users and their groups. Jiraissue obviously. roles, I'm not actually sure about. help you find the rest

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

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 ...

2,772 views 11 18
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot