https://community.cloudera.com/t5/Support-Questions/Setting-a-permission-in-hive-databases-but-it-does-not-work/m-p/155910#M118332 <P> help me please, I set the hive permission today, I modify the hive-site.xml as follows,but it does not work,I can not find where it is wrong.</P><P>This is a part of my hive-site.xml</P><P> &lt;property&gt; &lt;name&gt;hive.security.authorization.enabled&lt;/name&gt; &lt;value&gt;true&lt;/value&gt; &lt;/property&gt; &lt;property&gt; &lt;name&gt;hive.metastore.authorization.storage.checks&lt;/name&gt; &lt;value&gt;true&lt;/value&gt; &lt;final&gt;true&lt;/final&gt; &lt;/property&gt; &lt;property&gt; &lt;name&gt;hive.metastore.execute.setugi&lt;/name&gt; &lt;value&gt;false&lt;/value&gt; &lt;/property&gt; &lt;property&gt; &lt;name&gt;hive.users.in.admin.role&lt;/name&gt; &lt;value&gt;hive&lt;/value&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;/property&gt;</P><P>I create new table "test" use user "hive"(hive has admin role), then I use "useradd mxl" command to add user,and the mxl user can operate the table test, But i don't grant select or insert to user mxl ! Please tell why,thank you very much.</P> Tue, 14 Mar 2017 19:17:24 GMT 565109424 2017-03-14T19:17:24Z