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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You should do that with JQL, not SQL.
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.