You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Fang-Yu Rao (Jira)" <ji...@apache.org> on 2026/05/28 22:01:00 UTC

[jira] [Created] (IMPALA-15048) Consider showing more information in SHOW CURRENT ROLES after IMPALA-14954

Fang-Yu Rao created IMPALA-15048:
------------------------------------

             Summary: Consider showing more information in SHOW CURRENT ROLES after IMPALA-14954
                 Key: IMPALA-15048
                 URL: https://issues.apache.org/jira/browse/IMPALA-15048
             Project: IMPALA
          Issue Type: Task
            Reporter: Fang-Yu Rao


Consider showing more information in {{{}SHOW CURRENT ROLES{}}}.
 - After IMPALA-14954, we support the delegation of roles, and thus the grantee of a role could either be an administrator or a non-administrator for the role.
 - Moreover, a user could also be granted a role via the a group this user belongs to.

It could be seen that given a role {{{}r{}}}, it's possible that the current effective user belongs to 2 groups {{g_1}} and {{{}g_2{}}}, where the group {{g_1}} is a role administrator of the role {{{}r{}}}, but the group {{g_2}} is not a role administrator of the role r. To not lose this piece of information, we may need 4 columns in the result of {{{}SHOW CURRENT ROLES{}}}:
 - role_name.
 - user_name, which is set to null if the role was granted via a group.
 - group_name, which is set to null if the role was granted directly to the user.
 - grant_option.



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