Niklaus Xiao created HIVE-15483:
-----------------------------------
Summary: Database and table name is case sensitive when used in
show grant
Key: HIVE-15483
URL: https://issues.apache.org/jira/browse/HIVE-15483
Project: Hive
Issue Type: Bug
Components: Authorization, SQLStandardAuthorization
Affects Versions: 1.3.0, 2.2.0
Reporter: Niklaus Xiao
Assignee: Niklaus Xiao
Priority: Minor
When use SQLStdAuth, db name and table name is case sensitive when use {{show
grant}} command.
{code}
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)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
