https://community.cloudera.com/t5/Support-Questions/Setting-a-permission-in-hive-databases-but-it-does-not-work/m-p/155911#M118333 <P>Check what is in hive.security.authorization.manager. You will need to set that as well. It is a lot easier if you are using ambari to do it. </P><P>Take a look at <A href="https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization#SQLStandardBasedHiveAuthorization-ForHive0.14andNewer" target="_blank">https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization#SQLStandardBasedHiveAuthorization-ForHive0.14andNewer</A> for detailed configuration</P> Tue, 14 Mar 2017 20:50:33 GMT ravi1 2017-03-14T20:50:33Z