[jira] [Commented] (RANGER-2844) presto-server-333 can not show schemas/tables after integrated with Ranger master branch

["Jie Zhang (Jira)" <ji...@apache.org>]

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

Jie Zhang commented on RANGER-2844:
-----------------------------------

[~pradeep], Pradeep, could you help take a look at this when you get a chance please? Thanks a lot. 

> presto-server-333 can not show schemas/tables after integrated with Ranger master branch
> ----------------------------------------------------------------------------------------
>
>                 Key: RANGER-2844
>                 URL: https://issues.apache.org/jira/browse/RANGER-2844
>             Project: Ranger
>          Issue Type: Bug
>          Components: Ranger
>    Affects Versions: 2.1.0
>         Environment: Amazon Linux
>            Reporter: Jie Zhang
>            Assignee: Pradeep Agrawal
>            Priority: Blocker
>             Fix For: 2.1.0
>
>         Attachments: no show command.png
>
>
> Integrated presto-server-333 with Ranger master branch, able to run use/select queries, but got access denied when running *{color:#00875a}show schemas/tables{color}*. 
> I saw there is no {color:#00875a}*show*{color} command on ranger-ui (screenshot attached), is that why presto can not show schemas/tables? Any workaround? Thanks a lot. 
>  
> Error: 
> {code:java}
> presto:default> use default;
> USE
> presto:default> show schemas;
> Query 20200604_192311_00023_sa7kt failed: Access Denied: Cannot show schemas: hivepresto:default> show tables;
> Query 20200604_192319_00024_sa7kt failed: Access Denied: Cannot show tables of schema hive.default
> {code}



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