[SENTRY-1407] 'default' database is listed without having any grants on it

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.5.1
• Component/s: Hive V2
• Assignee: Unassigned
• Reporter: Matyas Orhidi
• Created: 15/Jul/16 15:09
• Updated: 31/Oct/18 16:33

Description

default database should not be listed when issuing the show database command and the user has no privileges on the object:

0: jdbc:hive2://localhost:10000/default> show current roles;
+---------------+--+
|     role      |
+---------------+--+
| analyst_role  |
+---------------+--+
1 row selected (0.086 seconds)
0: jdbc:hive2://localhost:10000/default> show grant role analyst_role;
+------------------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------------+----------+--+
|     database     | table  | partition  | column  | principal_name  | principal_type  | privilege  | grant_option  |    grant_time     | grantor  |
+------------------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------------+----------+--+
| sample_database  |        |            |         | analyst_role    | ROLE            | *          | false         | 1464280571499000  | --       |
+------------------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------------+----------+--+
1 row selected (0.087 seconds)
0: jdbc:hive2://localhost:10000/default> show databases;
+------------------+--+
|  database_name   |
+------------------+--+
| default          |
| sample_database  |
+------------------+--+
2 rows selected (0.137 seconds)
0: jdbc:hive2://localhost:10000/default>