When I gave a restriction to a column through Ranger , am able to access that through Hive command line and also in beeline command line. So does Ranger restrticts data only in Amabari view ?
Please suggest me if any more restriction is required.
Can you please provide the screen shot for your resource based policy views and also the particular policy details which restricts the column access.
@Dinesh Das 1. You can specify the multiple columns in the same policy no need create multiple policies. 2. Please check if you have enabled "all - database, table, column" policy that will enable access to all.
If its enabled disabled it and try again.
In Ranger, Policy Definition seems to be correct. After execution, can you please see the Ranger Audit to see if the audit entry for the access tells the policy-id that provided access for the column ?
the restriction working well in Ambari>>Hive view but beeline CLI I can able to do select on all columns.