screen-shot-2016-11-11-at-114102-am.pngscreen-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 !
