https://community.cloudera.com/t5/Support-Questions/Setting-a-permission-in-hive-databases-but-it-does-not-work/m-p/155914#M118336 <P>You will need to set the following in the hive-site.xml and restart the HiveServer2.</P><PRE>hive.server2.enable.doAs = false hive.security.authorization.manager = org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory hive.security.authenticator.manager = org.apache.hadoop.hive.ql.security.SessionStateUserAuthenticator hive.users.in.admin.role = hive hive.security.authorization.enabled = true</PRE><P>Note that the permissions are enforced in HS2 session only. So, if hive user created some table and did not explicitly give permissions to user mxl then mxl wouldn't be able to operate on it. Example</P><PRE>- Login as user hive and in beeline session run the following: create table test (key string, val int); - Now login as user mxl and in beeline session run the following: insert into table test select * from foo; You will see an error like "Permission denied. name=mxl does not have following privileges. INSERT." - To explicitly provide permissions, login as user hive in beeline session and run: grant insert on test to user mxl;</PRE><P>Hope this is what you were looking for, not very sure reading your question.</P> Tue, 14 Mar 2017 23:03:47 GMT deepesh1 2017-03-14T23:03:47Z