zqqnancy 发表于 2016-7-5 14:48 这应该属于对库的权限,楼主看的是对表的操作 |
qcbb001 发表于 2016-7-5 14:11 重置配置后:hive> set hive.metastore.authorization.storage.checks=true; hive> set hive.security.authorization.enabled=true; hive> show grant user hive on table authorization_test01; OK default authorization_test01 hive USER DELETE true 1467700837000 hive default authorization_test01 hive USER INSERT true 1467700837000 hive default authorization_test01 hive USER SELECT true 1467700837000 hive default authorization_test01 hive USER UPDATE true 1467700837000 hive Time taken: 0.335 seconds, Fetched: 4 row(s) hive> revoke DELETE on table authorization_test01 from user hive; OK Time taken: 0.667 seconds hive> revoke UPDATE on table authorization_test01 from user hive; OK Time taken: 0.544 seconds hive> show grant user hive on table authorization_test01; OK default authorization_test01 hive USER INSERT true 1467700837000 hive default authorization_test01 hive USER SELECT true 1467700837000 hive Time taken: 0.797 seconds, Fetched: 2 row(s) hive> DROP TABLE authorization_test01; OK Time taken: 1.629 seconds 只有INSERT和SELECT全限,我删除表可以删除,感觉权限控制并没有生效,查看配置已配,hive版本为 1.2.1000 |
zqqnancy 发表于 2016-7-5 14:07 可能已经授权的原因。尝试重置或则把配置hive.security.authorization.createtable.owner.grants all去掉 |
qcbb001 发表于 2016-7-5 13:49 已尝试过,不知为何,可正常创建 hive> set hive.security.authorization.enabled=true; hive> CREATE TABLE authorization_test (key int, value string); OK Time taken: 3.017 seconds hive> show tables; OK authorization_test |
楼主可以尝试下面方法 [mw_shl_code=bash,true]hive> set hive.security.authorization.enabled=true; hive> CREATE TABLE authorization_test (key int, value string); [/mw_shl_code] |