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 the user’s browser. No data are sent anywhere else. |
Security
Since no data are sent outside the user’s browser your organization’s data remains as secure as they already was before, without increasing potential security risks that might compromise the data at 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 relies on the atlassian’s public REST API there is no way to bypass the Jira security implementation and read non authorized data accidentally.
Scalability
Since it is a pure Javascript app, It 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 run the engine and resolve the queriesto run. Therefore, it scales along with the user base.
Reliability
It does not require any third party server to work. Therefore it does not introduce any new third-party potential point of failure providing up times close to 100%. All files (javascript, html pages, etc) are hosted on an 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.: more users → more available hardware, and more resources to run.
The lack of a third-party server 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 to into your organization with a implantation close to the SQL-99 specification.
...