title: Create database in console hive without permission in Ranger
body: <p>I have <code>not kerberos cluster Hadoop</code>. I manage the permission hive, hdfs via <code>Ranger</code>.
  The Resource Path in Ranger for HDFS are:</p>
  
  <pre><code>/user/myLogin
  /apps/hive/warehouse/mylogin_*
  /apps/hive/warehouse
  </code></pre>
  
  <p>I can create a database in hive ( <code>via console)</code> also in <code>Ambari</code>.
  But when I remove the permission <code>/apps/hive/warehouse</code> I can't create a database in Hive (Console) but in Ambari I can create it.</p>
  
  <p>This following the error:</p>
  
  <pre><code>hive&gt; 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                                                                                                                               rmissionChecker.java:353)
  </code></pre>
  
  <p>How can I create a database or runing a request in hive (console) without the permission <code>/apps/hive/warehouse</code> ? Because I should remove this permission from Ranger to allow access users only to there data.</p>
  
  <p>Thank you</p>