[HIVE-7061] sql std auth - insert queries without overwrite should not require delete privileges

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.13.0
• Fix Version/s: 0.14.0
• Component/s: Authorization, SQLStandardAuthorization
• Labels: TODOC14
• Assignee: Thejas Nair
• Reporter: Thejas Nair
• Created: 14/May/14 21:33
• Updated: 13/Nov/14 19:44
• Resolved: 23/May/14 15:46

Description

Insert queries can do the equivalent of delete and insert of all rows of a table or partition, if the overwrite keyword is used. As a result DELETE privilege is applicable to such queries.
However, SQL Standard auth requires DELETE privilege even for queries that don't have the overwrite keyword.

Issue Links

• links to: review board