[HIVE-4887] sql standard auth should disable commands that impose security risk

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.13.0
• Component/s: Authorization, Security
• Assignee: Ashutosh Chauhan
• Reporter: Thejas Nair
• Created: 19/Jul/13 01:16
• Updated: 27/Apr/14 08:12
• Resolved: 03/Apr/14 21:29

Description

Hive's RDBMS style of authorization (using grant/revoke), relies on all data access being done through hive select queries. But hive also supports running dfs commands, shell commands (eg "!cat file"), and shell commands through hive streaming.

This creates problems in securing a hive server using this authorization model. UDF is another way to write custom code that can compromise security, but you can control that by restricting access to users to be only through jdbc connection to hive server (2).

(note that there are other major problems such as this one - HIVE-3271)

Issue Links

• is related to: HIVE-5400 Allow admins to disable compile and other commands
• is related to: HIVE-6415 Disallow transform clause in sql std authorization mode
• is related to: HIVE-6827 Disable insecure commands with std sql auth