You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@sentry.apache.org by "Kalyan Kalvagadda (Jira)" <ji...@apache.org> on 2020/01/02 17:13:00 UTC

[jira] [Updated] (SENTRY-2411) SHOW GRANT ON authorozable does no display any user privileges on a authorizable

     [ https://issues.apache.org/jira/browse/SENTRY-2411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kalyan Kalvagadda updated SENTRY-2411:
--------------------------------------
    Fix Version/s:     (was: 2.2.0)
                   2.3.0

> SHOW GRANT ON authorozable does no display any user privileges on a authorizable
> --------------------------------------------------------------------------------
>
>                 Key: SENTRY-2411
>                 URL: https://issues.apache.org/jira/browse/SENTRY-2411
>             Project: Sentry
>          Issue Type: Improvement
>    Affects Versions: 2.1.0
>            Reporter: Krishna Kalyan
>            Assignee: Krishna Kalyan
>            Priority: Major
>             Fix For: 2.3.0
>
>
> {noformat}
> > show grant on table all_db.user1_t;
> INFO  : Compiling command(queryId=hive_20180919101818_e47a63b4-c005-4afa-a775-0c6420d0283f): show grant on table all_db.user1_t
> INFO  : Semantic Analysis Completed
> INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:database, type:string, comment:from deserializer), FieldSchema(name:table, type:string, comment:from deserializer), FieldSchema(name:partition, type:string, comment:from deserializer), FieldSchema(name:column, type:string, comment:from deserializer), FieldSchema(name:principal_name, type:string, comment:from deserializer), FieldSchema(name:principal_type, type:string, comment:from deserializer), FieldSchema(name:privilege, type:string, comment:from deserializer), FieldSchema(name:grant_option, type:boolean, comment:from deserializer), FieldSchema(name:grant_time, type:bigint, comment:from deserializer), FieldSchema(name:grantor, type:string, comment:from deserializer)], properties:null)
> INFO  : Completed compiling command(queryId=hive_20180919101818_e47a63b4-c005-4afa-a775-0c6420d0283f); Time taken: 0.064 seconds
> INFO  : Executing command(queryId=hive_20180919101818_e47a63b4-c005-4afa-a775-0c6420d0283f): show grant on table all_db.user1_t
> INFO  : Starting task [Stage-0:DDL] in serial mode
> INFO  : Completed executing command(queryId=hive_20180919101818_e47a63b4-c005-4afa-a775-0c6420d0283f); Time taken: 0.009 seconds
> INFO  : OK
> +-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
> | database  | table  | partition  | column  | principal_name  | principal_type  | privilege  | grant_option  | grant_time  | grantor  |
> +-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
> +-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+ {noformat}
>  
> However, if I use the 'show grant user', then it shows me the user has privileges on the table.
> {noformat}
> > show grant user user1;
> INFO  : Compiling command(queryId=hive_20180919101818_e86e01e4-3c29-4d7b-a161-450e16eb049c): show grant user user1
> INFO  : Semantic Analysis Completed
> INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:database, type:string, comment:from deserializer), FieldSchema(name:table, type:string, comment:from deserializer), FieldSchema(name:partition, type:string, comment:from deserializer), FieldSchema(name:column, type:string, comment:from deserializer), FieldSchema(name:principal_name, type:string, comment:from deserializer), FieldSchema(name:principal_type, type:string, comment:from deserializer), FieldSchema(name:privilege, type:string, comment:from deserializer), FieldSchema(name:grant_option, type:boolean, comment:from deserializer), FieldSchema(name:grant_time, type:bigint, comment:from deserializer), FieldSchema(name:grantor, type:string, comment:from deserializer)], properties:null)
> INFO  : Completed compiling command(queryId=hive_20180919101818_e86e01e4-3c29-4d7b-a161-450e16eb049c); Time taken: 0.061 seconds
> INFO  : Executing command(queryId=hive_20180919101818_e86e01e4-3c29-4d7b-a161-450e16eb049c): show grant user user1
> INFO  : Starting task [Stage-0:DDL] in serial mode
> INFO  : Completed executing command(queryId=hive_20180919101818_e86e01e4-3c29-4d7b-a161-450e16eb049c); Time taken: 0.006 seconds
> INFO  : OK
> +-----------+----------+------------+---------+-----------------+-----------------+------------+---------------+-------------------+----------+--+
> | database  |  table   | partition  | column  | principal_name  | principal_type  | privilege  | grant_option  |    grant_time     | grantor  |
> +-----------+----------+------------+---------+-----------------+-----------------+------------+---------------+-------------------+----------+--+
> | all_db    | user1_t  |            |         | user1           | USER            | owner      | false         | 1537377445287000  | --       |
> +-----------+----------+------------+---------+-----------------+-----------------+------------+---------------+-------------------+----------+--+ {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)