You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@sentry.apache.org by "Sravya Tirukkovalur (JIRA)" <ji...@apache.org> on 2015/07/24 22:33:04 UTC

[jira] [Updated] (SENTRY-819) select on all columns is not same as select on table

     [ https://issues.apache.org/jira/browse/SENTRY-819?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sravya Tirukkovalur updated SENTRY-819:
---------------------------------------
    Description: 
Right now select * fails even if users have permissions on all underlying columns.
Checked the behavior on SQL server:
It allows select *
If added a new column, then select * fails with "The SELECT permission was denied on the column 'colc' of the object 'Table_1', database 'testdb1', schema 'dbo'."

> select on all columns is not same as select on table
> ----------------------------------------------------
>
>                 Key: SENTRY-819
>                 URL: https://issues.apache.org/jira/browse/SENTRY-819
>             Project: Sentry
>          Issue Type: Bug
>    Affects Versions: 1.5.0
>            Reporter: Sravya Tirukkovalur
>             Fix For: 1.6.0
>
>
> Right now select * fails even if users have permissions on all underlying columns.
> Checked the behavior on SQL server:
> It allows select *
> If added a new column, then select * fails with "The SELECT permission was denied on the column 'colc' of the object 'Table_1', database 'testdb1', schema 'dbo'."



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