[ 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. when i grant select on the underlying table, the table view still don't have select privilege. > 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)