title: Hive cannot create roles and show roles in cloudera?
body: <p>I'm getting the error, once i given the command <strong>show roles;</strong> in the hive terminal. Kindly do help me, and i add some property in hive-site.xml.</p>
  
  <p>I am working in cloudera-quickstart-5.4.2.0-vmware.</p>
  
  <pre><code>&lt;property&gt;
  &lt;name&gt;hive.security.authorization.enabled&lt;/name&gt;
  &lt;value&gt;true&lt;/value&gt;
  &lt;description&gt;enable or disable the hive client     authorization&lt;/description&gt;
  &lt;/property&gt;
  
  &lt;property&gt;
  &lt;name&gt;hive.security.authorization.createtable.owner.grants&lt;/name&gt;
  &lt;value&gt;ALL&lt;/value&gt;
  &lt;description&gt;the privileges automatically granted to the owner whenever a table gets created. 
  An example like "select,drop" will grant select and drop privilege to the owner of the table&lt;/description&gt;
  &lt;/property&gt;
  </code></pre>
  
  <hr>
  
  <pre><code>[cloudera@quickstart ~]$ hive
  
  Logging initialized using configuration in jar:file:/usr/jars/hive-common-1.1.0-cdh5.4.2.jar!/hive-log4j.properties
  WARNING: Hive CLI is deprecated and migration to Beeline is recommended.
  hive&gt; show roles;
  FAILED: SemanticException The current builtin authorization in Hive is incomplete and disabled.
  </code></pre>
  
  <p>I am waiting for the answers.
  Thanks in Advance</p>