Jira admins must grant the rest of the users with Global permission.

Sharing queries with third parties requires explicit user authorization.All the SQL queries can be safely shared among the Jira users since they invoke the underlying Atlassian’s public REST API. Therefore, the same SQL query can return different values for users depending on their permissions in Jira.

In spite of all the queries can be executed safely by anyone in the question of results, there are some measures of admin control. Constraints are applied for writing queries from the console and gadgets, and running queries from third-party tools. Jira Administrator can configure who can do it via global permissions:

...

Users granted that global permission “SQL Cloud Write” are able to access the built-in SQL Cloud Query console, write their queries and use all its instruments.

...

To be able to run a query in a third-party tool User need permission “SQL Cloud Connect“ which gives access to SQL Cloud Server, through which he can share queries usingJDBC/ODATA

...