title: FAILED: HiveAccessControlException Permission denied: Principal [name=user1, type=USER] does not have following privileges for operation CREATETABLE
body: <p>I am trying to create table using hive create query and getting below error-</p>
  <pre><code>Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: Principal [name=username, type=USER] does not have following privileges for operation CREATETABLE [[OBJECT OWNERSHIP] on Object [type=DATABASE, name=dbname]] (state=42000,code=40000)
  </code></pre>
  <p>I tried to give grant createtable but it seems it's not valid grant, How we can give create table grant to hive user, we don't want to give drop database access so can't add user in owner role.</p>