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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Bug
• Affects Version/s: 2.1.0
• Fix Version/s: 2.1.0
• Component/s: Ranger
• Environment: Amazon Linux
• Flags: Important
• Assignee: Bolke de Bruin
• Reporter: Jie Zhang
• Created: 04/Jun/20 19:19
• Updated: 16/Oct/20 01:50
• Resolved: 09/Jun/20 22:47

Description

Integrated presto-server-333 with Ranger master branch, able to run use/select queries, but got access denied when running show schemas/tables. 

I saw there is no show command on ranger-ui (screenshot attached), is that why presto can not show schemas/tables? Any workaround? Thanks a lot. 

 

Error: 

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