https://community.cloudera.com/t5/Support-Questions/How-to-manage-Hive-warehouse-HDFS-directory-permission/m-p/189268#M151361 <P>You should set the permission of Hive warehouse as 700 instead of 000, so that normal users are unable to access the secured tables, and let Ranger control the Hive policies. </P><P>In addition, you will need to make sure 'hive.warehouse.subdir.inherit.perms=true', that will enforce the newly created tables inherit the 700 permission.</P><P>Hope that helps.</P> Tue, 18 Jul 2017 22:10:11 GMT dsun 2017-07-18T22:10:11Z