https://community.cloudera.com/t5/Support-Questions/Ranger-Hive-Plugin/m-p/313931#M225811 <P>Hi All,</P> <P>&nbsp;</P> <P>I have a single node vanilla hadoop cluster installed with root user. Below are the versions on the server.</P> <P>Hadoop 3.1.0</P> <P>HBase 2.2.3</P> <P>Hive 3.1.0</P> <P>Ranger 3.0.0-SNAPSHOT</P> <P>&nbsp;</P> <P>I have installed apache ranger-admin and ranger-usersync, which is configured to sync with local LDAP which is configured on a different server.</P> <P>I have enabled the plugin for hive service, which is hadoop-sql now.&nbsp;</P> <P>Also I have created a policy for one of the ldap user to deny access to one of the hive DB. But, after enabling hive plugin, apart from the user root, none of the users is able to see any tables ( show tables returns empty set, though there are tables), but it shows all the databases for all the users ( including the one I denied in policy).</P> <P>&nbsp;</P> <P>Can someone please help on the same. Please let me know if more information / logs are needed.</P> Fri, 02 Apr 2021 12:55:57 GMT shaz11 2021-04-02T12:55:57Z