You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sentry.apache.org by "Lenni Kuff (JIRA)" <ji...@apache.org> on 2015/11/05 09:22:27 UTC
[jira] [Updated] (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:all-tabpanel ]
Lenni Kuff updated SENTRY-679:
------------------------------
Issue Type: Bug (was: New Feature)
> 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
> Fix For: 1.7.0
>
>
> {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
(v6.3.4#6332)