[
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)
