[
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)
