pengquan21
pengquan21
New Contributor

Re: 'show databases' fails with access-denied when...

by New Contributor pengquan21 in Support Questions
‎08-10-2018 06:19 AM
‎08-10-2018 06:19 AM
According to the following link : https://cwiki.apache.org/confluence/display/RANGER/Hive+Commands+to+Ranger+Permission+Mapping I add the resource based policy "database=default table=\* column= \* " and the permission is "select". But it failed with access-denied. And then I modify the policy to "database=\* table=\* column= \* " , it would be ok. ... View more

'show databases' fails with access-denied when use...

by New Contributor pengquan21 in Support Questions
‎08-09-2018 01:03 AM
‎08-09-2018 01:03 AM
I am working with Ranger the user, ranger, which has access to database default. When Execute ‘show databases;’ via beeline;the user [hive] 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) When I changed the policy ' db=default; table=\*; col=\* ' to ' db=\*; table=\*; col=\*' then execute ‘show databases;’ It would be ok. Ranger verion:1.0.0 Thanks ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎08-24-2018 02:14 AM
Public Statistics
Date Registered ‎08-07-2018 01:29 PM
Last Visited ‎08-24-2018 02:14 AM
Total Messages Posted 2