Hive权限管理员设定 - Githubissues

cloudnativecube / octopus

14 stars 2 forks source link

Hive权限管理员设定 #121

Open MichaelGou1105 opened 3 years ago

MichaelGou1105 commented 3 years ago

场景

 hive开启权限后，与ranger对接时，需要设定用户为管理员用户

命令

hive-site.xml

    <property>
        <name>hive.security.authorization.enabled</name>
        <value>true</value>
    </property>
    <property>
        <name>hive.security.authorization.createtable.owner.grants</name>
        <value>ALL</value>
    </property>
    <property>
        <name>hive.users.in.admin.role</name>
        <value>hive</value>
    </property>

hive cli

    > set hive.users.in.admin.role
    hive.users.in.admin.role=hive
    > set role admin
    > create role test;
    OK