HIVE身份验证

三、HIVE身份验证

1.开启Hive的身份认证功能，默认是false

<property>
  <name>hive.security.authorization.enabled</name> 
  <value>true</value>
  <description>Enable or disable the hive client authorization</description>
</property>

2.表创建者用于的权限配置项

<property>
  <name>hive.security.authorization.createtable.owner.grants</name>
  <value>ALL</value>
  <description>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</description>
</property>

这个配置默认是NULL，建议将其设置成ALL，让用户能够访问自己创建的表。

详见 http://yugouai.iteye.com/blog/1864772