sentry-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dapeng Sun (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SENTRY-679) Sentry support for Hive 0.14 Insert into table table_name values (...)
Date Tue, 01 Sep 2015 05:50:52 GMT

     [ https://issues.apache.org/jira/browse/SENTRY-679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Dapeng Sun updated SENTRY-679:
------------------------------
    Fix Version/s:     (was: 1.6.0)
                   1.7.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: New Feature
>    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)

Mime
View raw message