You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ranger.apache.org by "Haihui Xu (JIRA)" <ji...@apache.org> on 2019/05/23 08:17:00 UTC

[jira] [Commented] (RANGER-2185) Hive Plugin show databases permission denied when user has access to some of the databases

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

Haihui Xu commented on RANGER-2185:
-----------------------------------

I find that ranger 1.1.0 has the same issue. But the solution of [~dhomme] maybe not good enough。

The method “isShowDatabasesAccessAllowed(request)” should not in RangerHiveAuthorizer.java（ranger-hive-plugin）

what about the offical solution？[~rmani]

> Hive Plugin show databases permission denied when user has access to some of the databases
> ------------------------------------------------------------------------------------------
>
>                 Key: RANGER-2185
>                 URL: https://issues.apache.org/jira/browse/RANGER-2185
>             Project: Ranger
>          Issue Type: Bug
>          Components: plugins
>    Affects Versions: 1.0.0
>            Reporter: dhomme
>            Priority: Major
>              Labels: security
>         Attachments: 0001-RANGER-2185-fix-hive-show-databases-bug.patch
>
>
> Add a  resource based policy to allow a user, hive, has access to the default database. Then execute 'show databases;' via beeline, the user should see 'default'. Instead following error is shown:
> Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [hive] does not have [USE] privilege on [*] (state=42000,code=40000)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)