You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@sentry.apache.org by "Na Li (JIRA)" <ji...@apache.org> on 2018/09/13 17:17:00 UTC
[jira] [Commented] (SENTRY-679) Sentry support for Hive 0.14 Insert
into table table_name values (...)
[ 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.com@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.com@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.com@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.com@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.com@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.com@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.com@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)