Julian Hyde created CALCITE-5681:
------------------------------------
Summary: Support authorization via GRANT and REVOKE DDL commands
Key: CALCITE-5681
URL: https://issues.apache.org/jira/browse/CALCITE-5681
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
Support authorization via GRANT and REVOKE DDL commands.
While CALCITE-2194 describes how authorization could be built into the schema
(e.g. user1 can see tables table1 and table2), it requires people to create
their own Schema objects. This feature would add GRANT and REVOKE commands to
the DDL parser in the "server" component.
The syntax is TBD but would look something like this:
{code:java}
GRANT SELECT ON TABLE table1, table2 TO user1;
REVOKE ALL ON table1 FROM user1; {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
