You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Thejas M Nair (JIRA)" <ji...@apache.org> on 2013/12/05 22:59:35 UTC

[jira] [Created] (HIVE-5969) SQL std auth - authorize create database

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)