Hive Security using Apache Ranger

karan_alang1 — Sat, 12 Nov 2016 03:43:14 GMT

Hello All,

I've configured Hive Security using Apache Ranger, however have a basic question since it doesnt seem t be working as i expected.

Link followed ->

Here is the scenario :

for user - raj_ops, i've removed access to Hive tables (all tables) through Apache Ranger

So, when i try to execute the following query using user - "Hive view" through Ambari, as expected - access is denied.

Next Step -

I logon to sandbox console using user - raj_ops, and logon to hive, and query table "customer" - I'm able to access the rows in the table !

Any idea why this is so, and what do i need to ensure user - raj_ops is not able to access the Hive table.

STEPS used for logging in to Sandbox & querying

> ssh raj_ops@sandbox.hortonworks.com -p 222

> hive

> use foodmart

> select * from foodmart.customer;

Pls see screenshot attached, raj_ops is able to access the table contents !

Re: Hive Security using Apache Ranger

srai1 — Sat, 12 Nov 2016 04:09:46 GMT

Hive shell is not secured through ranger, its only hiveserver2.

Try what you were trying using beeline or a JDBC app. It should not allow you to get in.