[jira] [Commented] (SENTRY-552) Downgrading privileges does not always work for column-level privileges

["Dapeng Sun (JIRA)" <ji...@apache.org>]

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

Dapeng Sun commented on SENTRY-552:
-----------------------------------

Hi [~lskuff], thank you for report the bug. I will fix it

> Downgrading privileges does not always work for column-level privileges
> -----------------------------------------------------------------------
>
>                 Key: SENTRY-552
>                 URL: https://issues.apache.org/jira/browse/SENTRY-552
>             Project: Sentry
>          Issue Type: Bug
>    Affects Versions: 1.5.0
>            Reporter: Lenni Kuff
>            Assignee: Dapeng Sun
>             Fix For: 1.5.0
>
>
> The following doesn't work properly:
> grant all on col1
> grant all on col2
> revoke select on col2
> -- at this point, will have ALL on col1, INSERT on col2
> revoke INSERT from table <--- Does not do the proper thing.
> The expectation is that revoking INSERT from the table would remove INSERT privilege on col2 and also downgrade the ALL privilege on col1 to SELECT. Instead the privilege on col1 stays in-tact. 
> Note that this was exposed as part of the fix for SENTRY-543. Prior to that the REVOKE would incorrectly remove both privileges.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)