[
https://issues.apache.org/jira/browse/SENTRY-679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Na Li updated SENTRY-679:
-------------------------
Fix Version/s: (was: 2.1.0)
> Sentry support for Hive 0.14 Insert into table table_name values (...)
> ----------------------------------------------------------------------
>
> Key: SENTRY-679
> URL: https://issues.apache.org/jira/browse/SENTRY-679
> Project: Sentry
> Issue Type: Bug
> Affects Versions: 1.5.0
> Reporter: Anne Yu
> Assignee: Prasad Mujumdar
> Priority: Major
>
> {code}
> ++ sudo -u hive beeline --color --silent=true -u
> 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[email protected]'
> -n hive -p hive -e 'drop role insert_table'
> ++ sudo -u hive beeline --color --silent=true -u
> 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[email protected]'
> -n hive -p hive -e 'CREATE ROLE insert_table'
> ++ sudo -u hive beeline --color --silent=true -u
> 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[email protected]'
> -n hive -p hive -e 'GRANT INSERT ON TABLE test2 to ROLE insert_table'
> ++ sudo -u hive beeline --color --silent=true -u
> 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[email protected]'
> -n hive -p hive -e 'GRANT ROLE insert_table TO GROUP hive'
> ++ sudo -u hive beeline --color --silent=true -u
> 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[email protected]'
> -n hive -p hive -e 'GRANT SELECT ON TABLE t1 to role insert_table'
> ++ sudo -u hive beeline --color --silent=true -u
> 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[email protected]'
> -n hive -p hive -e 'SET ROLE insert_table' -e 'insert into table test2
> select * from t1'
> ++ sudo -u hive beeline --color --silent=true -u
> 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[email protected]'
> -n hive -p hive -e 'SET ROLE insert_table' -e 'insert into table test2
> values ('\''test'\'')'
> Error: Error while compiling statement: FAILED: SemanticException No valid
> privileges
> Required privileges for this query:
> Server=server1->Db=default->Table=values__tmp__table__1->action=select;
> (state=42000,code=40000)
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
