[jira] [Resolved] (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:all-tabpanel ]

Jie Zhang resolved RANGER-2844.
-------------------------------
    Resolution: Not A Bug

Created a new mysql server, setup everything again, now able to see show command. Sorry for the false alarm. 

> 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: Bolke de Bruin
>            Priority: Major
>             Fix For: 2.1.0
>
>         Attachments: got access denied for show command.png, 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)