[jira] [Commented] (SENTRY-846) [column level privilege] show table extended doesn't require table level privilege

["Hadoop QA (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SENTRY-846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14723376#comment-14723376 ] 

Hadoop QA commented on SENTRY-846:
----------------------------------

Here are the results of testing the latest attachment
https://issues.apache.org/jira/secure/attachment/12753270/SENTRY-846.001.patch against master.

{color:green}Overall:{color} +1 all checks pass

{color:green}SUCCESS:{color} all tests passed

Console output: https://builds.apache.org/job/PreCommit-SENTRY-Build/828/console

This message is automatically generated.

> [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.5.1
>            Reporter: Anne Yu
>            Assignee: guoquan
>         Attachments: SENTRY-846.001.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)