[jira] [Updated] (HIVE-2818) Create table checks the current database privilege

["Navis (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-2818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Navis updated HIVE-2818:
------------------------

    Attachment: HIVE-2818.1.patch.txt

Based on HIVE-2093

> Create table checks the current database privilege
> --------------------------------------------------
>
>                 Key: HIVE-2818
>                 URL: https://issues.apache.org/jira/browse/HIVE-2818
>             Project: Hive
>          Issue Type: Bug
>          Components: Authorization, Security
>    Affects Versions: 0.7.1
>            Reporter: Benyi Wang
>            Assignee: Navis
>         Attachments: HIVE-2818.1.patch.txt
>
>
> Hive seems check the current database to determine the privilege of a statement when you use fully qualified name like 'database.table'
>  
> {code}
> hive> set hive.security.authorization.enabled=true;
> hive> create database test_db;
> hive> grant all on database test_db to user test_user;
> hive> revoke all on database default from test_user;
> hive> use default;
> hive> create table test_db.new_table (id int);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
> hive> use test_db;
> hive> create table test_db.new_table (id int);
> {code}



--
This message was sent by Atlassian JIRA
(v6.1#6144)