Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
1.3.0, 2.2.0
-
None
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)