[HIVE-1915] authorization on database level is broken.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Component/s: Authorization, Metastore, Security
• Hadoop Flags: Reviewed
• Assignee: He Yongqiang
• Reporter: He Yongqiang
• Created: 14/Jan/11 23:20
• Updated: 10/Oct/12 19:39
• Resolved: 19/Jan/11 22:37

Description

CREATE DATABASE IF NOT EXISTS test_db COMMENT 'Hive test database';
SHOW DATABASES;

grant `drop` on DATABASE test_db to user hive_test_user;
grant `select` on DATABASE test_db to user hive_test_user;

show grant user hive_test_user on DATABASE test_db;
DROP DATABASE IF EXISTS test_db;

will fail.