[
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)
