hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brock Noland (JIRA)" <>
Subject [jira] [Commented] (HIVE-6629) Discuss SET ROLE NONE
Date Wed, 12 Mar 2014 13:53:45 GMT


Brock Noland commented on HIVE-6629:

Hey [~thejas] I created this blocker not because I am trying to be difficult, but because
I feel we need to discuss this before the 0.13 release as I find SET ROLE NONE to be counter-intuitive.
If we decided to change that behavior to SET ROLE ALL, I'd be more than happy to create the
patch myself, today.

FYI [~rhbutani]

> ---------------------
>                 Key: HIVE-6629
>                 URL:
>             Project: Hive
>          Issue Type: Task
>    Affects Versions: 0.13.0
>            Reporter: Brock Noland
>            Priority: Blocker
>             Fix For: 0.13.0
> I understand this is well after it's been implemented. However, I think we need to discuss
the counter-intuitive SET ROLE syntax before we release 0.13.
> The new Hive Authz work implements "SET ROLE NONE" similar to MySQL meaning that "SET
ROLE NONE" actually sets your role to the default. This is extremely counter-intuitive.
> * [Oracle|]

> * [Informix|]
> * [Vertica|]
> * [SAP|]
> All of the widely deployed databases have "SET ROLE NONE" disable all privileges. Those
databases have the intuitive "SET ROLE ALL" or "SET ROLE DEFAULT" enable all privileges.

This message was sent by Atlassian JIRA

View raw message