[ https://issues.apache.org/jira/browse/HIVE-6204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14239081#comment-14239081 ]
Dapeng Sun commented on HIVE-6204: ---------------------------------- Hello @[~navis], I created a jira HIVE-9018 may related with this. would you help to review when time allows. > The result of show grant / show role should be tabular format > ------------------------------------------------------------- > > Key: HIVE-6204 > URL: https://issues.apache.org/jira/browse/HIVE-6204 > Project: Hive > Issue Type: Improvement > Components: Authorization > Reporter: Navis > Assignee: Navis > Priority: Minor > Fix For: 0.13.0 > > Attachments: HIVE-6204.1.patch.txt, HIVE-6204.2.patch.txt, > HIVE-6204.3.patch.txt > > > {noformat} > hive> show grant role role1 on all; > OK > database default > table src > principalName role1 > principalType ROLE > privilege Create > grantTime Wed Dec 18 14:17:56 KST 2013 > grantor navis > database default > table srcpart > principalName role1 > principalType ROLE > privilege Update > grantTime Wed Dec 18 14:18:28 KST 2013 > grantor navis > {noformat} > This should be something like below, especially for JDBC clients. > {noformat} > hive> show grant role role1 on all; > OK > default src role1 ROLE Create false > 1387343876000 navis > default srcpart role1 ROLE Update false > 1387343908000 navis > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)