https://community.cloudera.com/t5/Support-Questions/How-to-manage-Hive-warehouse-HDFS-directory-permission/m-p/189267#M151360 <P>I have a HDP-2.6 cluster. I would like to control access to Hive tables through Ranger. I would also like to run my queries as an end-user. I followed HDP documentation of Ranger and set up 000 permission for directory /apps/warehouse/hive.</P><P>What I noticed while working is, Ranger policies doesn't solely work on policies created for Hive(database and tables). Though if a user has WRITE permission defined in Ranger policy, it still needs WRITE permission for the corresponding table's directory in HDFS. If my database has 1000+ tables and a user needs WRITE permission only for 200 tables, then I have to create ranger HDFS policy(s) for those 200 directories with WRITE permission to the user.</P><P>I can give WRITE permission at a database level however, I am worried about a possibility for user removes files of other tables from command line.</P> Tue, 18 Jul 2017 21:22:11 GMT antonyshajin 2017-07-18T21:22:11Z