Support Questions
Find answers, ask questions, and share your expertise

HIVE Permissions

Expert Contributor

Hello,

How do I setup user permissions in hive?

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

Thanks,

Marcy

5 REPLIES 5

Re: HIVE Permissions

Expert Contributor

@Marcy

You can enable to Ranger Plug-in for Hive, and centrally manage all of the policies from the Ranger UI:

https://hortonworks.com/hadoop-tutorial/manage-security-policy-hive-hbase-knox-ranger/

You can then define a policy to Grant or Deny access to the table.

Re: HIVE Permissions

Expert Contributor

@Graham Martin

Hello,

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

Re: HIVE Permissions

Cloudera Employee
@Marcy

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:

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_Sys_Admin_Guides/content/ref-746ce51a-9b...

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_installing_manually_book/content/install...

Hope that helps

Re: HIVE Permissions

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

Re: HIVE Permissions

Explorer