[ https://issues.apache.org/jira/browse/SENTRY-679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16613815#comment-16613815 ]
Na Li commented on SENTRY-679: ------------------------------ [~spena] should we close this as won't fix? > 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/anneyu-sentry-ha-10-4.ent.cloudera....@ent.cloudera.com' > -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/anneyu-sentry-ha-10-4.ent.cloudera....@ent.cloudera.com' > -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/anneyu-sentry-ha-10-4.ent.cloudera....@ent.cloudera.com' > -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/anneyu-sentry-ha-10-4.ent.cloudera....@ent.cloudera.com' > -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/anneyu-sentry-ha-10-4.ent.cloudera....@ent.cloudera.com' > -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/anneyu-sentry-ha-10-4.ent.cloudera....@ent.cloudera.com' > -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/anneyu-sentry-ha-10-4.ent.cloudera....@ent.cloudera.com' > -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)