Created on 03-21-2017 02:01 PM - edited 09-16-2022 04:18 AM
How do I setup user permissions in hive?
For example, I would like to revoke select on a table.
Created 03-21-2017 02:13 PM
You can enable to Ranger Plug-in for Hive, and centrally manage all of the policies from the Ranger UI:
You can then define a policy to Grant or Deny access to the table.
Created 03-21-2017 02:21 PM
Created 03-23-2017 03:17 AM
For earlier hive versions (and if you are not running Ranger), you can try SQL Standard Auth: https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization.
However, it is preferred to use Ranger for fine grained authorization. You can find details here:
Hope that helps
Created 03-23-2017 03:44 PM
@Graham Martin @Vaibhav Gumashta
How do I create a user in Hadoop?
How do I set HIVE permissions for this user using Ranger?
I think my problem is that I did not create the user properly. Therefore, the Ranger permissions is not working....
Also, I wish to test this in sandbox... is all the configurations/programs already on the sandbox? or must I install more?
Is there special sqoop commands that must be done in order for Ranger/HIVE permissions to work? must i set --warehouse-dir???
Created 03-27-2017 09:22 PM
Hope this link helps you with HDFS user setup: https://docs.hortonworks.com/HDPDocuments/Ambari-22.214.171.124/bk_ambari_views_guide/content/_setup_HDFS_u...