BELUGA BEHR commented on SENTRY-2134:

Perhaps, for simplicity sake, Sentry Sync can be keyed off URI alone and no 
longer on database/table location.  Not only is it simple, but it will give 
flexibility because two tables, within the same database, Sentry can control 
Hive/Impala access to both but allow only one to be open on HDFS.  Finally, 
there is no need to worry about a database/table location and a URI colliding.

> Apply Hive URI grants recursively to subdirectories
> ---------------------------------------------------
>                 Key: SENTRY-2134
>                 URL: https://issues.apache.org/jira/browse/SENTRY-2134
>             Project: Sentry
>          Issue Type: Improvement
>          Components: Hive Binding
>    Affects Versions: 1.8.0, 2.0.0, 1.7.1
>            Reporter: Ruslan Dautkhanov
>            Priority: Major
>              Labels: hive, uri
> Currently we need to add direct grants for all Hive tables' LOCATIONs. 
> Like, 'hdfs_staging/table1', 'hdfs_staging/table2', etc.. 
> It's not manageable this way. - we can't add grants for each and every table. 
> It would be great if we could just do one grant - 
> 'hdfs_staging/' so it would automatically be applied to  
> 'hdfs_staging/table1', 'hdfs_staging/table2', and other subdirectories.
> There is probably a reason this wasn't implemented earlier? Thanks for 
> considering this improvement.
> Also found another user's request on this - 
> https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Impala-Sentry-GRANT-ALL-ON-URI-not-cascaded-down-through/td-p/39928

This message was sent by Atlassian JIRA

Reply via email to