Extracting information from the jira database

Can the JIRA database be extracted according to information
below regarding JIRA users?


• Profile access information (within the project) "Permissions"

• Account creation data in the application.

• Profile modification / privilege data.

2 answers

0 vote
Micky Caritte Community Champion Jan 12, 2018

Hi Luiz,

The short answer is yes. Database stores everything so basically you can extract it all. The real challenge is to gather all what you need. For instance on your first point, permissions can be managed through direct profile in permission schemes, groups or even Roles.

More info on the database scheme can be found here: https://developer.atlassian.com/server/jira/platform/database-schema/

I advise you to try it out and if you struggle with precise points, we might help you getting to your point :)


0 vote

Be aware that some of the information is not stored.  Either because it's simply not written to the database, or it done by business logic.

The database can give you the permissions, and the raw user information including groups (but not a history of profile change).  In most cases, you'll be able to do the basic stuff like "Permission X is granted to role Y, whom Dave belongs to because he is in group Z", but you're going to have loads of "fun" when the more clever ones kick in.  For example, "Dave can log work on this issue because he is named in field X on this issue" and "Dave can approve this because he is the assignee"

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Apr 17, 2018 in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

765 views 2 19
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