[HIVE-15483] Database and table name is case sensitive when used in show grant

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.3.0, 2.2.0
• Fix Version/s: 3.0.0
• Component/s: Authorization, SQLStandardAuthorization
• Assignee: Niklaus Xiao
• Reporter: Niklaus Xiao
• Created: 21/Dec/16 06:48
• Updated: 22/May/18 23:58
• Resolved: 16/May/17 06:50

Description

When use SQLStdAuth, db name and table name is case sensitive when use show grant command.

0: jdbc:hive2://localhost:21066/> show grant on table p1;
+-----------+--------+------------+---------+----------------------+-----------------+------------+---------------+----------------+----------+--+
| database  | table  | partition  | column  |    principal_name    | principal_type  | privilege  | grant_option  |   grant_time   | grantor  |
+-----------+--------+------------+---------+----------------------+-----------------+------------+---------------+----------------+----------+--+
| default   | p1     |            |         | userx                | USER            | DELETE     | true          | 1481872357000  | userx    |
| default   | p1     |            |         | userx                | USER            | INSERT     | true          | 1481872357000  | userx    |
| default   | p1     |            |         | userx                | USER            | SELECT     | true          | 1481872357000  | userx    |
| default   | p1     |            |         | userx                | USER            | UPDATE     | true          | 1481872357000  | userx    |
+-----------+--------+------------+---------+----------------------+-----------------+------------+---------------+----------------+----------+--+
7 rows selected (0.158 seconds)

0: jdbc:hive2://localhost:21066/> show grant on table P1;
+-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
| database  | table  | partition  | column  | principal_name  | principal_type  | privilege  | grant_option  | grant_time  | grantor  |
+-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
+-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
No rows selected (9.608 seconds)
0: jdbc:hive2://localhost:21066/> show grant on table defaulT.p1;
+-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
| database  | table  | partition  | column  | principal_name  | principal_type  | privilege  | grant_option  | grant_time  | grantor  |
+-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
+-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
No rows selected (0.06 seconds)