Create table checks the current database privilege --------------------------------------------------
Key: HIVE-2818 URL: https://issues.apache.org/jira/browse/HIVE-2818 Project: Hive Issue Type: Bug Affects Versions: 0.7.1 Reporter: Benyi Wang Hive seems check the current database to determine the privilege of a statement when you use fully qualified name like 'database.table' {code} hive> set hive.security.authorization.enabled=true; hive> create database test_db; hive> grant all on database test_db to user test_user; hive> revoke all on database default from test_user; hive> use default; hive> create table test_db.new_table (id int); Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details. hive> use test_db; hive> create table test_db.new_table (id int); {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira