[
https://issues.apache.org/jira/browse/SENTRY-743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14640956#comment-14640956
]
Sravya Tirukkovalur commented on SENTRY-743:
--------------------------------------------
Here is the behavior with SQL server:
User has select(cola):
> select colb from <tab>
The SELECT permission was denied on the column 'colb' of the object 'Table_1',
database 'testdb1', schema 'dbo'.
>select *
The SELECT permission was denied on the column 'colb' of the object 'Table_1',
database 'testdb1', schema 'dbo'.
>select colc
Invalid column name 'colc'.
> [Column level privileges] Column existence should be hidden for users with no
> privileges on that column
> -------------------------------------------------------------------------------------------------------
>
> Key: SENTRY-743
> URL: https://issues.apache.org/jira/browse/SENTRY-743
> Project: Sentry
> Issue Type: Bug
> Affects Versions: 1.5.0
> Reporter: Sravya Tirukkovalur
> Assignee: Sravya Tirukkovalur
> Fix For: 1.6.0
>
>
> Column existence should be hidden for users with no privileges on that
> column. For example:
> - Select * should return columns for which users have privilege
> - select c1 when user does not have permission on that column should fail
> with column not found exception rather than permission denied error.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
