How do I setup user permissions in hive?
For example, I would like to revoke select on a table.
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.
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
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???