[
https://issues.apache.org/jira/browse/SENTRY-846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14901483#comment-14901483
]
Anne Yu commented on SENTRY-846:
--------------------------------
[~guoquan], for 1.5.1, show table extended requires table level privileges. so
I will move affected version to 1.7 or later.
> [column level privilege] show table extended doesn't require table level
> privilege
> -----------------------------------------------------------------------------------
>
> Key: SENTRY-846
> URL: https://issues.apache.org/jira/browse/SENTRY-846
> Project: Sentry
> Issue Type: Bug
> Components: Hive Plugin
> Affects Versions: 1.7.0
> Reporter: Anne Yu
> Assignee: guoquan
> Attachments: SENTRY-846.001.patch, SENTRY-846.002.patch
>
>
> use column level privilege,
> {code}
> 0: jdbc:hive2://anneyu-cdh55-1.vpc.cloudera.c> show tables in test_db like
> 'test_tb';
> +-----------+--+
> | tab_name |
> +-----------+--+
> | test_tb |
> +-----------+--+
> show table extended in test_db like 'test_tb';
> Error: Error while compiling statement: FAILED: SemanticException No valid
> privileges
> Required privileges for this query:
> Server=server1->Db=test_db->Table=test_tb->action=insert;Server=server1->Db=test_db->Table=test_tb->action=select;
> (state=42000,code=40000)
> {code}
> Do we want to let user see their column info ? such as,
> {noformat}
> columns:struct columns { string s, i32 i}
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
