You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by "Abhay Kulkarni (Jira)" <ji...@apache.org> on 2023/05/03 03:19:00 UTC

[jira] [Created] (RANGER-4219) Grant permission in Impala engine not working with {user} in ranger policy

Abhay Kulkarni created RANGER-4219:
--------------------------------------

             Summary: Grant permission in Impala engine not working with {user} in ranger policy
                 Key: RANGER-4219
                 URL: https://issues.apache.org/jira/browse/RANGER-4219
             Project: Ranger
          Issue Type: Bug
          Components: Ranger
            Reporter: Abhay Kulkarni
            Assignee: Abhay Kulkarni


1. users "test" and user has its own database "utest"
2. Ranger policy to grant permissions:
—
Database: u

{USER}
table: *
columns: *

Allow Conditions: user: \{USER}

permission: ALL +Delegate Admin
—

The grant does not work for Impala GRANTs. The following error is seen.

> GRANT SELECT ON TABLE utest.testtable TO ROLE rolename;

The response is:
InternalException: Error granting a privilege in Ranger. Ranger error message: HTTP 403 Error: User doesn't have necessary permission to grant access



--
This message was sent by Atlassian Jira
(v8.20.10#820010)