You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Arina Ielchiieva (Jira)" <ji...@apache.org> on 2020/03/23 08:52:00 UTC
[jira] [Assigned] (DRILL-7151) Show only accessible tables when
Hive authorization enabled
[ https://issues.apache.org/jira/browse/DRILL-7151?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva reassigned DRILL-7151:
---------------------------------------
Assignee: (was: Igor Guzenko)
> Show only accessible tables when Hive authorization enabled
> -----------------------------------------------------------
>
> Key: DRILL-7151
> URL: https://issues.apache.org/jira/browse/DRILL-7151
> Project: Apache Drill
> Issue Type: Improvement
> Reporter: Igor Guzenko
> Priority: Minor
>
> The SHOW TABLES for Hive worked inconsistently for very long time.
> Before changes introduced by DRILL-7115 only accessible tables were shown only when Hive Storage Based Authorization is enabled, but for SQL Standard Based Authorization all tables were shown to user ([related discussion|https://github.com/apache/drill/pull/461#discussion_r58753354]).
> In scope of DRILL-7115 the only accessible restriction for Storage Based Authorization was weakened in order to improve query performance.
> There is still need to improve security of Hive show tables query and at the same time do not violate performance requirements.
> For SQL Standard Based Authorization this can be done by asking ```HiveAuthorizationHelper.authorizerV2``` for table's 'SELECT' permission.
> For Storage Based Authorization performance acceptable approach is not known for now, one of ideas is try using appropriate Hive storage based authorizer class for the purpose.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)