[
https://issues.apache.org/jira/browse/RANGER-2844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jie Zhang updated RANGER-2844:
------------------------------
Description:
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}
!Screen Shot 2020-06-04 at 12.07.49 PM.png!
was:
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}
> 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: 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}
> !Screen Shot 2020-06-04 at 12.07.49 PM.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
