[
https://issues.apache.org/jira/browse/SENTRY-847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14708009#comment-14708009
]
guoquan commented on SENTRY-847:
--------------------------------
Hi [~anneyu], I am afraid that I don't understand your meaning. Take your
command for example, when the test_user1 has select privilege on test_tb(s),
the command "show columns in test_tb" should return the column he has select
privilege on or throw a invalid exception. I am not sure about this. Can you
help me to figure it out. Thanks.
> [column level privilege] show columns in test_tb requires table level
> privilege
> -------------------------------------------------------------------------------
>
> Key: SENTRY-847
> URL: https://issues.apache.org/jira/browse/SENTRY-847
> Project: Sentry
> Issue Type: Bug
> Affects Versions: 1.5.1
> Reporter: Anne Yu
>
> {code}
> grant select(s) on table test_tb to role test_role;
> show columns in 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}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
