[
https://issues.apache.org/jira/browse/HIVE-15687?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lantao Jin reassigned HIVE-15687:
---------------------------------
Assignee: Lantao Jin
> SQL Standard auth: INSERT and DELETE privileges don't actually exist.
> ---------------------------------------------------------------------
>
> Key: HIVE-15687
> URL: https://issues.apache.org/jira/browse/HIVE-15687
> Project: Hive
> Issue Type: Bug
> Reporter: Carter Shanklin
> Assignee: Lantao Jin
>
> The documentation states
> https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization#SQLStandardBasedHiveAuthorization-ObjectPrivilegeCommands
> that there are privilege types of INSERT | SELECT | UPDATE | DELETE | ALL.
> Experience suggests otherwise:
> {code}
> : jdbc:hive2://localhost:10000/default> grant select on table secured_table
> to role my_role;
> No rows affected (0.034 seconds)
> 0: jdbc:hive2://localhost:10000/default> grant insert on table secured_table
> to role my_role;
> Error: Error while compiling statement: FAILED: SemanticException Undefined
> privilege Insert (state=42000,code=40000)
> 0: jdbc:hive2://localhost:10000/default> grant update on table secured_table
> to role my_role;
> No rows affected (0.037 seconds)
> 0: jdbc:hive2://localhost:10000/default> grant delete on table secured_table
> to role my_role;
> Error: Error while compiling statement: FAILED: SemanticException Undefined
> privilege Delete (state=42000,code=40000)
> 0: jdbc:hive2://localhost:10000/default> select version();
> +--------------------------------------------------------------+--+
> | _c0 |
> +--------------------------------------------------------------+--+
> | 2.1.0.2.6.0.0-369 r434bfeb707d21f6b44121ac7dfe5adbadb746387 |
> +--------------------------------------------------------------+--+
> {code}
> It would be good to support these, especially since Hive supports updates and
> deletions.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
