[ https://issues.apache.org/jira/browse/HIVE-6204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13895854#comment-13895854 ]
Lefty Leverenz commented on HIVE-6204: -------------------------------------- Okay, thanks [~navis]. So far, the wiki doesn't have any examples of output for SHOW GRANT or SHOW ROLE. We could mention format changes in 0.13.0 without giving examples, or expand the doc with sample statements and their outputs before & after this patch. Doc locations: * [Design Docs: AuthDev: show grant |https://cwiki.apache.org/confluence/display/Hive/AuthDev#AuthDev-4.2showgrant] -- no information * [Language Manual: Hive Authorization: Viewing Granted Roles |https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Authorization#LanguageManualAuthorization-ViewingGrantedRoles] -- syntax only * [Language Manual: Hive Authorization: Viewing Granted Privileges |https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Authorization#LanguageManualAuthorization-ViewingGrantedPrivileges] -- syntax only * [Language Manual: DDL: Show Granted Roles and Privileges |https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowGrantedRolesandPrivileges] -- just links to sections in the Authorization doc No need to document hive.in.test in the wiki but when HIVE-6387 gets committed, the description for hive.test.mode might need revision. * [Configuration Properties: Test Properties |https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-TestProperties] Anything else? > 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.1.5#6160)