What Do I Do If the View Owner Does Not Have the Permission on Functions?

Question

When you access a view of an independently deployed Hive data source and a function is used in the Hive view, the error message "view owner does not have sufficient privileges" may be displayed.

Figure 1 Error message

Answer

The Ranger permission of HetuEngine controls function permissions. If the view owner of the independently deployed Hive data source cluster does not have a user with the same name in the cluster, the function permission configured in Ranger cannot be granted to the user. Perform the following operations to grant permission to the user and refer to Adding a Ranger Access Permission Policy for HetuEngine:

• Solution 1

  Create a user with the same name as the view owner in the cluster and modify the all-function policy in the Ranger access permission policy of HetuEngine.

  1. In the Allow Condition area, enter the authorized view owner in the Select User text box.
  2. In Permissions, select Grant and execute.

• Solution 2

  Modify the all-function policy in the Ranger access permission policy of HetuEngine to grant all users the following permissions:

  1. In the Allow Condition area, select {USER} from the Select User box.
  2. In Permissions, select Grant and execute.

  If you need to manage the function permission of a specific user, you can configure Deny Conditions.

  1. Select a user from Select User.
  2. In Permissions, select Grant and execute to disable the function permissions of the user.