[
https://issues.apache.org/jira/browse/RANGER-2185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16576773#comment-16576773
]
Ramesh Mani commented on RANGER-2185:
-------------------------------------
[~dhomme] Solution you are proposing is very invasive in policy engine and not
recommended at all.
You may need to revisit this and see if this an can be addressed in ranger hive
plugin.
Also when I tried this in the current version, I couldn't reproduce this and
worked as expected, so I am not sure which version of ranger you tested this
with.
> 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-showdatabases-permission-when-user-h.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)
