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)

Reply via email to