[jira] [Created] (IGNITE-11712) SQL: review security check for SQL/DML queries

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (IGNITE-11712) SQL: review security check for SQL/DML queries

Anton Vinogradov (Jira)
Roman Kondakov created IGNITE-11712:
---------------------------------------

             Summary: SQL: review security check for SQL/DML queries
                 Key: IGNITE-11712
                 URL: https://issues.apache.org/jira/browse/IGNITE-11712
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Roman Kondakov


Currently the security check (read/write permissions) is carried out during the query execution. It involves some extra actions (like a query registration) which can be avoided if the security check is conducted on the earlier stage of the query execution, for example right away after the parsing.

For SELECT queries only read permission should be checked.

For INSERT queries without SELECT only write permission should be checked.

For  UPDATE queries or INSERT queries with SELECT both read and write permissions should be checked.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)