What is the query to retrieve the issue list for a user with specific permissions in JIRA DB?
-> Query for ORACLE
For example, please provide the query to retrieve the issue list for a user with the username [123456] in JIRA DB who has the necessary permissions to view the issues.
