I add a internal ranger user to a hive policy and test the policy in hive, it works.
But if I try to add a user-group which I created in Ranger with the user I tried it before to a hive policy, it doesn't work.
I don't have LDAP activated in this test cluster.
can you please mention what is the operation you are trying to do? , and please see runas configuration is true or false , if it is false then please check whether hive user also has permissions.
Sorry for my bad discription...this is a test cluster for a specific usecase. I want to add about 10 users manually in ranger and split them into 3 user-groups.
In ranger-hive I want to create 3 policys and each policy get's one user-group.
If I know add a new user to a user-group, I only add them to the group and must not edit the hive policy.
actually i wanted to know the hive operation that is failing , and you can post complete stack of the hive operation response , like what is the error you are getting after running hive command
An exception was caught. Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [dummy] does not have [USE] privilege on [test]
the hive runas configuration is false. If I add the user dummy direct to the permission, it works. If I just add the group, it doesn't work.
I'm working with Toad for Apache Hadoop. I created a user for ambari with just read only rights. Then I connect toad to the hdp cluster. An now I edit the configuration and set the user to dummy. So now I don't see any databases etc.
I create a hive policy in ranger with all rights for user dummy.
I can't find a good description how the user concept in hdp is working, and how to setup ranger without ldap etc...