hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Liao, Xiaoge (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-9463) Table view don't have Authorization to select by other user
Date Mon, 26 Jan 2015 06:33:34 GMT

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

Liao, Xiaoge updated HIVE-9463:
-------------------------------
    Description: 
i upgrade from 0.10.0 to 0.13.1, but we meet a problem as below:
For 0.10.0, when user A create table view, user B have select privilege to read data.
But for 0.13.1, user B can't have rights.

Command:
user A:
hive> create view table_view as select * from xx;
user B:
hive> select * from table_view;
Authorization failed:No privilege 'Select' found for inputs { database:default, table:table_view}.
Use SHOW GRANT to get more details.

when i grant select on the underlying table, the table view still don't have select privilege.


  was:
i upgrade from 0.10.0 to 0.13.1, but we meet a problem as below:
For 0.10.0, when user A create table view, user B have select privilege to read data.
But for 0.13.1, user B can't have rights.

Command:
user A:
hive> create view table_view as select * from xx;
user B:
hive> select * from table_view;
Authorization failed:No privilege 'Select' found for inputs { database:default, table:table_view}.
Use SHOW GRANT to get more details.


> Table view don't have Authorization to select by other user
> -----------------------------------------------------------
>
>                 Key: HIVE-9463
>                 URL: https://issues.apache.org/jira/browse/HIVE-9463
>             Project: Hive
>          Issue Type: Bug
>          Components: Authorization
>    Affects Versions: 0.13.1
>            Reporter: Liao, Xiaoge
>
> i upgrade from 0.10.0 to 0.13.1, but we meet a problem as below:
> For 0.10.0, when user A create table view, user B have select privilege to read data.
> But for 0.13.1, user B can't have rights.
> Command:
> user A:
> hive> create view table_view as select * from xx;
> user B:
> hive> select * from table_view;
> Authorization failed:No privilege 'Select' found for inputs { database:default, table:table_view}.
Use SHOW GRANT to get more details.
> when i grant select on the underlying table, the table view still don't have select privilege.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message