[
https://issues.apache.org/jira/browse/HIVE-5923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thejas M Nair updated HIVE-5923:
--------------------------------
Release Note:
Grant privilege and revoke privilege statements don't have the requirement (but
not the option) for the noise word TABLE.
TABLE is the assumed default for grant and revoke statements.
Hive’s syntax changes from "GRANT action ON TABLE table TO grantee" to "GRANT
action ON [TABLE] table TO grantee".
Grant role and revoke role statements has been changed to remove the need for
keyword ROLE.
Support for WITH ADMIN OPTION has been added to grant role and revoke role
statement syntax.
was:
Grant privilege and revoke privilege statements need to be changed to remove
the requirement (but not the option) for the noise word TABLE. In the SQL
specification table is the assumed default for grant and revoke statements.
Today Hive’s syntax is GRANT action ON TABLE table TO grantee. It should be
GRANT action ON [TABLE] table TO grantee.
Grant role and revoke role statements has been changed to remove the need for
keyword ROLE.
Support for WITH ADMIN OPTION needs to be added to grant role and revoke role
statement syntax.
> SQL std auth - parser changes
> -----------------------------
>
> Key: HIVE-5923
> URL: https://issues.apache.org/jira/browse/HIVE-5923
> Project: Hive
> Issue Type: Sub-task
> Components: Authorization
> Reporter: Thejas M Nair
> Assignee: Thejas M Nair
> Fix For: 0.13.0
>
> Attachments: HIVE-5923.1.patch, HIVE-5923.2.patch, HIVE-5923.3.patch,
> HIVE-5923.4.patch
>
> Original Estimate: 96h
> Time Spent: 72h
> Remaining Estimate: 12h
>
> There are new access control statements proposed in the functional spec in
> HIVE-5837 . It also proposes some small changes to the existing query syntax
> (mostly extensions and some optional keywords).
> The syntax supported should depend on the current authorization mode.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
