Allowing Users without ADMIN Permission to Create Temporary Functions

Scenario

You must have ADMIN permission when creating temporary functions on Hive of the open source community version.

MRS Hive provides a configuration switch. The default value is true, that is, creating temporary functions requires the ADMIN permission, which is consistent with the open source community version.

You can modify configurations of this function. After the function is enabled, you can create temporary functions without ADMIN permission. If this parameter is set to false, security risks exist.

The security mode supports the configuration of whether the ADMIN permission is required for creating temporary functions, but the common mode does not support this function.

Procedure

1. Log in to FusionInsight Manager. Click Cluster, choose Services > Hive, click Configurations, and then All Configurations.
2. Enter the parameter name in the search box, search for hive.security.temporary.function.need.admin, change the parameter value to true or false, and restart all HiveServer instances.
   

   • If this parameter is set to true, the ADMIN permission is required for creating temporary functions, which is the same as that in the open source community.
   • If this parameter is set to false, the ADMIN permission is not required for creating temporary functions.