You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@sentry.apache.org by "Matyas Orhidi (JIRA)" <ji...@apache.org> on 2016/07/15 15:11:20 UTC
[jira] [Updated] (SENTRY-1407) 'default' database is listed without
having any grants on it
[ https://issues.apache.org/jira/browse/SENTRY-1407?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Matyas Orhidi updated SENTRY-1407:
----------------------------------
Description:
{code}
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>
{code}
was:
{{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> }}
> 'default' database is listed without having any grants on it
> ------------------------------------------------------------
>
> Key: SENTRY-1407
> URL: https://issues.apache.org/jira/browse/SENTRY-1407
> Project: Sentry
> Issue Type: Bug
> Components: Hive V2
> Affects Versions: 1.5.1
> Reporter: Matyas Orhidi
>
> {code}
> 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>
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)