Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Tue, 3 Dec 2013 04:15:36 +0000 (UTC)
From: "Thejas M Nair (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12682299.1386044040097.59528.1386044136411@arcas>
In-Reply-To: <JIRA.12682299.1386044040097@arcas>
References: <JIRA.12682299.1386044040097@arcas>
Subject: [jira] [Commented] (HIVE-5923) sql std auth - parser changes
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/HIVE-5923?page=3Dcom.atlassian.=
jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D13837=
309#comment-13837309 ]=20

Thejas M Nair commented on HIVE-5923:
-------------------------------------


new statements in proposal=20
- SET ROLE
- SHOW CURRENT ROLES
- SHOW ALL ROLES
- DESCRIBE ROLE


- Grant privilege and revoke privilege statements need to be changed to rem=
ove the requirement (but not the option) for the noise word TABLE.  In the =
SQL specification table is the assumed default for grant and revoke stateme=
nts.  Today Hive=E2=80=99s syntax is GRANT action ON TABLE table TO grantee=
.  It should be GRANT action ON [TABLE] table TO grantee.
- Grant privilege and revoke privilege statements need to be changed to rem=
ove the requirement to specify whether the grantee is a user or role.  That=
 is, today Hive=E2=80=99s syntax is GRANT action ON [TABLE] table TO grante=
e where grantee is USER|ROLE identifier.  The keywords USER or ROLE do not =
belong here.  It should not be legal to have a role that shares a name with=
 a user.  For backward compatibility we will allow these extra keywords but=
 warn that the usage is deprecated.
- Grant role and revoke role statements need to be changed to remove the ke=
yword ROLE.  Current Hive syntax is GRANT ROLE rolename TO grantee.  It sho=
uld be GRANT rolename TO grantee.  The same applies for revoke role.
- Support for WITH ADMIN OPTION needs to be added to grant role and revoke =
role statements.
- Support for GRANTED BY needs to be added to all grant and revoke statemen=
ts.
- Privileges INSERT and DELETE need to be added to the language.
- New statements SHOW ROLE and SHOW ROLE roleid need to be added to the lan=
guage.


> 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
>
> There are new access control statements proposed in the functional spec i=
n HIVE-5837 . It also proposes some small changes to the existing query syn=
tax (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#6144)