How can i get JIRA database connection information and how can i get grant access on it
You can find most of it in the system information page.
But I strongly recommend that you do not bother. You won't be writing to the database (with some minor exceptions, writing to a Jira database will break it, possibly catastrophically), and reading it is a nightmare because it has evolved as a data store, it simply is not designed for reporting.
What are you trying to do with this access?
I want to get all close cases for some time period.
You should do that with JQL, not SQL.
It looks like you're new here. Sign in or register to get started.