Thejas M Nair created HIVE-5969: ----------------------------------- Summary: SQL std auth - authorize create database Key: HIVE-5969 URL: https://issues.apache.org/jira/browse/HIVE-5969 Project: Hive Issue Type: Sub-task Reporter: Thejas M Nair
Permission to create a database must be given to any user, with the following caveats - The user must have HDFS rights to create a directory in the Hive warehouse directory, if no database location is specified; - or the user must own the directory provided in the database location specification (in this case it is recommended but not required that the group of the directory be hive, so that the hive user has access to the data in the database); - and if the database is owned by a role (rather than a user) the directory must be owned by the hive user. -- This message was sent by Atlassian JIRA (v6.1#6144)