You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sentry.apache.org by "Anne Yu (JIRA)" <ji...@apache.org> on 2015/09/22 23:20:04 UTC
[jira] [Created] (SENTRY-898) [column level privilege] with column
level privilege, show partitions fails, SemanticException No valid
privileges
Anne Yu created SENTRY-898:
------------------------------
Summary: [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
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)