[
https://issues.apache.org/jira/browse/SENTRY-898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ke Jia updated SENTRY-898:
--------------------------
Status: Patch Available (was: Open)
> [column level privilege] with column level privilege, show partitions fails,
> SemanticException No valid privileges
> ------------------------------------------------------------------------------------------------------------------
>
> Key: SENTRY-898
> URL: https://issues.apache.org/jira/browse/SENTRY-898
> Project: Sentry
> Issue Type: Bug
> Components: Sentry
> Affects Versions: 1.5.1
> Reporter: Anne Yu
> Assignee: Hao Hao
>
> If grant column level privilege to test user on a partition, show partitions
> fails to list the permitted partition with Error: Error while compiling
> statement: FAILED: SemanticException No valid privileges;
> {code}
> CREATE TABLE pageviews (userid VARCHAR(64), link STRING, came_from STRING)
> PARTITIONED BY (datestamp STRING, counter INT) CLUSTERED BY (userid) INTO 256
> BUCKETS STORED AS ORC;
> grant select(datestamp) on table pageviews to role test_par;
> grant role test_par to group test_user;
> show partitions pageviews;
> {code}
> cc [~guoquan], [~sravya], [~lskuff]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
