[HIVE-2405] get_privilege does not get user level privilege

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Authorization, Security
• Hadoop Flags: Reviewed
• Assignee: He Yongqiang
• Reporter: He Yongqiang
• Created: 24/Aug/11 19:36
• Updated: 11/Apr/12 21:48
• Resolved: 14/Sep/11 00:24

Description

hive> set hive.security.authorization.enabled=true;
hive> grant all to user heyongqiang;
hive> show grant user heyongqiang;
principalName heyongqiang
principalType USER
privilege All
grantTime Wed Aug 24 11:51:54 PDT 2011
grantor heyongqiang
Time taken: 0.032 seconds
hive> CREATE TABLE src (foo INT, bar STRING);
Authorization failed:No privilege 'Create' found for outputs

{ database:default}

. Use show grant to get more details.