https://kintosoft.atlassian.net/wiki/spaces/SQLC Here you can read more about security and permissions
Data privacy
...
& security
Everything runs on the user’s browser with no third-party server listening to your data!
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
All the data remains private between Jira and user’s browser. No data are sent anywhere else. |
Security
Since no data has been sent outside the user’s browser, your organization’s data remains secure as it has already been before, without increasing potential security risks that might compromise the data of your organization.
In addition, it runs in the security context of the current user, honoring the host application permissions (Jira).
It shares the same user’s HTTP session. Since it is based on the atlassian’s public REST API , it is not possible to bypass Jira's security implementation and accidentally read unauthorized data.
All the SQL queries are resolved against Atlassian’s public REST API to fetch all the data. Therefore, it is not possible to read unauthorized data under any circumstance.
So, it allows setting up a group of experienced users in SQL to write and share queries with the rest of the teams at your organization.
Dashboards built using our technology are safe as each user only sees the authorized data in Jira.
...
Reliability & Scalability
As it's a pure Javascript app, hence it runs on the user’s browser and reuses the user’s hardware tun to run the engine and resolve the queries. Therefore, it scales along with the user base.
Reliability
It doesn't require any : more users → more available hardware, and more resources to run.
The lack of a third-party server to work. Therefore, it doesn’t introduce any new third-party potential point of failure, providing up times close to 100%. All files (javascript, html pages, etc) are hosted on Amazon’s CloudFront cache service distributed on several locations along the World. Once it is downloaded and initialized locally, everything happens between Jira and the user’s browser.makes it a reliable app with no extra points of failure and awesome up times.
...
Industry-standards
It brings all the benefits and power of the SQL language into your organization with an implantation close to the SQL-99 specification.
...