How can we remove the restriction from the hive, is there any property which we can enable/set for whitelisting the user or command ? UPDATE : After going through the hive documentation (https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization), it has been stated that "Commands such as dfs, add, delete, compile, and reset are disabled when this authorization is enabled" I really wanted to understand the logic behind the above statement. ... View more