You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by "JackYan (JIRA)" <ji...@apache.org> on 2018/12/11 09:50:01 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=16716703#comment-16716703 ]
JackYan commented on RANGER-2185:
---------------------------------
I used the version 1.2.0,and I also met this trouble too. I given a user some privilege like this,database:default
table:test column:*,then I login using this user.When I executed 'show databases;', I got message like this, 'Permission denied: user [xxx] does not have [USE] privilege on [*]'.But, I can exectue 'use default;' and 'show tables;'.
Did anyone else have this problem?And how you solved it?
Sorry for my poor English.
> 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)