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

t oo commented on RANGER-2754:
------------------------------

[~bolke] have i configured something wrong or is the $partitions built-in table 
always blocked?

select * from hive.src_tdm."vv$partitions"

io.prestosql.spi.security.AccessDeniedException: Access Denied: Cannot select 
from columns [datestr, hourstr, source, region] in table or view vv$partitions
 at 
io.prestosql.spi.security.AccessDeniedException.denySelectColumns(AccessDeniedException.java:401)
 at 
io.prestosql.spi.security.AccessDeniedException.denySelectColumns(AccessDeniedException.java:396)
 at 
org.apache.ranger.authorization.presto.authorizer.RangerSystemAccessControl.checkCanSelectFromColumns(RangerSystemAccessControl.java:549)
 at 
org.apache.ranger.authorization.presto.authorizer.RangerSystemAccessControl.checkCanSelectFromColumns(RangerSystemAccessControl.java:234)
 at 
io.prestosql.security.AccessControlManager.lambda$checkCanSelectFromColumns$56(AccessControlManager.java:677)
 at 
io.prestosql.security.AccessControlManager.systemAuthorizationCheck(AccessControlManager.java:889)
 at 
io.prestosql.security.AccessControlManager.checkCanSelectFromColumns(AccessControlManager.java:677)
 at 
io.prestosql.security.ForwardingAccessControl.checkCanSelectFromColumns(ForwardingAccessControl.java:279)
 at io.prestosql.sql.analyzer.Analyzer.lambda$null$0(Analyzer.java:88)
 at java.base/java.util.LinkedHashMap.forEach(Unknown Source)
 at io.prestosql.sql.analyzer.Analyzer.lambda$analyze$1(Analyzer.java:87)
 at java.base/java.util.LinkedHashMap.forEach(Unknown Source)
 at io.prestosql.sql.analyzer.Analyzer.analyze(Analyzer.java:86)
 at io.prestosql.sql.analyzer.Analyzer.analyze(Analyzer.java:75)
 at io.prestosql.execution.SqlQueryExecution.analyze(SqlQueryExecution.java:217)
 at io.prestosql.execution.SqlQueryExecution.<init>(SqlQueryExecution.java:176)
 at io.prestosql.execution.SqlQueryExecution.<init>(SqlQueryExecution.java:93)
 at 
io.prestosql.execution.SqlQueryExecution$SqlQueryExecutionFactory.createQueryExecution(SqlQueryExecution.java:705)
 at 
io.prestosql.dispatcher.LocalDispatchQueryFactory.lambda$createDispatchQuery$0(LocalDispatchQueryFactory.java:121)
 at io.prestosql.$gen.Presto_333____20200510_221302_2.call(Unknown Source)
 at 
com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:125)
 at 
com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:69)
 at 
com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:78)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at java.base/java.lang.Thread.run(Unknown Source)

> Update presto dependency and implement row/column level security
> ----------------------------------------------------------------
>
>                 Key: RANGER-2754
>                 URL: https://issues.apache.org/jira/browse/RANGER-2754
>             Project: Ranger
>          Issue Type: Improvement
>          Components: plugins
>    Affects Versions: master
>            Reporter: Bolke de Bruin
>            Assignee: Bolke de Bruin
>            Priority: Major
>             Fix For: 2.1.0
>
>         Attachments: 
> 0001-RANGER-2754-Upgrade-presto-dependency-and-improve-lo.patch, 
> 0001-RANGER-2754-Upgrade-presto-dependency-and-improve-lo.patch, 
> 0001-RANGER-2754-Upgrade-presto-dependency-and-improve-lo.patch, 
> 0001-RANGER-2754-Upgrade-presto-dependency-and-improve-lo.patch, 
> 0001-RANGER-2754-Upgrade-presto-dependency-and-improve-lo.patch, 
> 0001-RANGER-2754-Upgrade-presto-dependency-and-improve-lo.patch, 
> 0001-RANGER-2754-Upgrade-presto-dependency-and-improve-lo.patch, 
> 0001-RANGER-2754-Upgrade-presto-dependency-and-improve-lo.patch, 
> 0001-RANGER-2754-Upgrade-presto-dependency-and-improve-lo.patch, 
> RANGER-2754-v2.patch, RANGER-2754.patch
>
>
> 1. PrestoSql has changed its Security API hence the Ranger plugin has stopped 
> working for versions > ~321. 
> 2. Presto master now has row/column level security support



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to