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.
A user should be having proper permissions on the default database. I quite didn't understand on what was the difference between your two attempts.
According to the following link :
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.