https://community.cloudera.com/t5/Support-Questions/Hive-access-not-audited-in-Ranger-in-HDP-2-5-sandbox/m-p/149133#M111659 <P>I am working not the Tag Based Polices tutorial (<A href="http://hortonworks.com/hadoop-tutorial/tag-based-policies-atlas-ranger/" rel="nofollow noopener noreferrer" target="_blank">http://hortonworks.com/hadoop-tutorial/tag-based-policies-atlas-ranger/</A>).</P><P>I created the "policy to access employee data". Then I started Hive view as maria_dev. When I tried the query I got the permission denied error message as expected. However, when I open the ranger audit page and go to the access tab, I don't see the permission error logged.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8882-screen-shot-2016-10-25-at-124014-pm.png" style="width: 2764px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/21288i882BA223D3BAC957/image-size/medium?v=v2&amp;px=400" role="button" title="8882-screen-shot-2016-10-25-at-124014-pm.png" alt="8882-screen-shot-2016-10-25-at-124014-pm.png" /></span></P><P>Here is a screen shot of my hive audit settings:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8883-screen-shot-2016-10-25-at-123554-pm.png" style="width: 1950px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/21289i6183FC023F8EA6D1/image-size/medium?v=v2&amp;px=400" role="button" title="8883-screen-shot-2016-10-25-at-123554-pm.png" alt="8883-screen-shot-2016-10-25-at-123554-pm.png" /></span></P> Sun, 18 Aug 2019 13:08:39 GMT Carolyn 2019-08-18T13:08:39Z https://community.cloudera.com/t5/Support-Questions/Hive-access-not-audited-in-Ranger-in-HDP-2-5-sandbox/m-p/149133#M111659 <P>I am working not the Tag Based Polices tutorial (<A href="http://hortonworks.com/hadoop-tutorial/tag-based-policies-atlas-ranger/" rel="nofollow noopener noreferrer" target="_blank">http://hortonworks.com/hadoop-tutorial/tag-based-policies-atlas-ranger/</A>).</P><P>I created the "policy to access employee data". Then I started Hive view as maria_dev. When I tried the query I got the permission denied error message as expected. However, when I open the ranger audit page and go to the access tab, I don't see the permission error logged.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8882-screen-shot-2016-10-25-at-124014-pm.png" style="width: 2764px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/21288i882BA223D3BAC957/image-size/medium?v=v2&amp;px=400" role="button" title="8882-screen-shot-2016-10-25-at-124014-pm.png" alt="8882-screen-shot-2016-10-25-at-124014-pm.png" /></span></P><P>Here is a screen shot of my hive audit settings:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8883-screen-shot-2016-10-25-at-123554-pm.png" style="width: 1950px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/21289i6183FC023F8EA6D1/image-size/medium?v=v2&amp;px=400" role="button" title="8883-screen-shot-2016-10-25-at-123554-pm.png" alt="8883-screen-shot-2016-10-25-at-123554-pm.png" /></span></P> Sun, 18 Aug 2019 13:08:39 GMT https://community.cloudera.com/t5/Support-Questions/Hive-access-not-audited-in-Ranger-in-HDP-2-5-sandbox/m-p/149133#M111659 Carolyn 2019-08-18T13:08:39Z https://community.cloudera.com/t5/Support-Questions/Hive-access-not-audited-in-Ranger-in-HDP-2-5-sandbox/m-p/149134#M111660 <P>The ranger audit logs were going in but there were so many the hive entries did not appear on the first page even when looking at ranger right after the query. After filtering by ServiceType hive and Result: Denied I was able to find the denied query:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8884-screen-shot-2016-10-25-at-41539-pm.png" style="width: 2110px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/21287i705A8D9CF1EF4E3B/image-size/medium?v=v2&amp;px=400" role="button" title="8884-screen-shot-2016-10-25-at-41539-pm.png" alt="8884-screen-shot-2016-10-25-at-41539-pm.png" /></span></P> Sun, 18 Aug 2019 13:08:25 GMT https://community.cloudera.com/t5/Support-Questions/Hive-access-not-audited-in-Ranger-in-HDP-2-5-sandbox/m-p/149134#M111660 Carolyn 2019-08-18T13:08:25Z