Support Questions

Find answers, ask questions, and share your expertise

HIVE Permissions

Expert Contributor


How do I setup user permissions in hive?

For example, I would like to revoke select on a table.




Expert Contributor


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.

Expert Contributor

@Graham Martin


When I do "HIVE View", it is an empty screen...

Cloudera Employee

For earlier hive versions (and if you are not running Ranger), you can try SQL Standard Auth:

However, it is preferred to use Ranger for fine grained authorization. You can find details here:

Hope that helps

Expert Contributor

@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???