How to select Issues from Database based on Permissions

Hi

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.

Regards,

Areg

1 answer

0 vote

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.

https://developer.atlassian.com/display/JIRADEV/Database+Schemashould help you find the rest

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

133 views 0 3
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