Thanks a lot Tamil Selvan K for this article, it's very useful. I have a question please and I hope find the best answer, I should do a permission to a database and not a tables. I have not kerberos cluster Hadoop . I manage the permission hive, hdfs via Ranger . The Resource Path in Ranger for HDFS are: /user/myLogin /apps/hive/warehouse/mylogin_* /apps/hive/warehouse I can create a database in hive ( via console) also in Ambari. But when I remove the permission /apps/hive/warehouse I can't create a database in Hive (Console) but in Ambari I can create it. This following the error: hive> create database database_tesst; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTa sk. MetaException(message:org.apache.hadoop.security.AccessControlException: Permission denied: user=AAAAA, access=EXECUTE, inode="/apps/hive/warehouse/database_tesst.db":hdfs:hdfs:d--------- at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPe How can I create a database or runing a request in hive (console) without the permission /apps/hive/warehouse ? Because I should remove this permission from Ranger to allow access users only to there data. ... View more