Hive Security using Apache Ranger

[#1]

screen-shot-2016-11-11-at-114102-am.png

screen-shot-2016-11-11-at-114026-am.png

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

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

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 !

[#2 · Accepted solution]

@Karan Alang

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.