Abhay Kulkarni created RANGER-2858:
--------------------------------------
Summary: "Show databases" gives permission denied error, even
though the user has permissions on a few of the databases in security zone
policies
Key: RANGER-2858
URL: https://issues.apache.org/jira/browse/RANGER-2858
Project: Ranger
Issue Type: Bug
Components: Ranger
Affects Versions: 2.0.0
Reporter: Abhay Kulkarni
Assignee: Abhay Kulkarni
Fix For: 2.1.0
However, I have issues while performing -
* show databases;
When user has permissions on a few of the databases in security zone policies,
"show databases" command is expected to list databases on which the user has
some permission in any security zone(s). However, the command fails with the
following message.
============
FAILED: HiveAccessControlException Permission denied: user [behemoth] does not
have [USE] privilege on [Unknown resource!!]
org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAccessControlException:
Permission denied: user [behemoth] does not have [USE] privilege on [Unknown
resource!!]
at
org.apache.ranger.authorization.hive.authorizer.RangerHiveAuthorizer.checkPrivileges(RangerHiveAuthorizer.java:487)
============
Furthermore, command "use <database>" where <database> is name of the database
where user has some access in any security zone, succeeds.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
