[SENTRY-847] [column level privilege] if grant column level privilege to user, show columns in table shouldn't require extra table level privilege

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.1
• Fix Version/s: hive_plugin_v2, 1.6.0
• Assignee: shenguoquan
• Reporter: Anne Yu
• Created: 13/Aug/15 22:51
• Updated: 28/Oct/15 07:34
• Resolved: 28/Aug/15 10:31

Description

grant select(s) on table test_tb to role test_role;

show columns in test_tb;

Error: Error while compiling statement: FAILED: SemanticException No valid privileges
 Required privileges for this query: Server=server1->Db=test_db->Table=test_tb->action=insert;Server=server1->Db=test_db->Table=test_tb->action=select; (state=42000,code=40000)

Issue Links

• Is contained by: SENTRY-74 Add column-level privileges for Hive/Impala