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

["Thejas M Nair (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-5969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thejas M Nair updated HIVE-5969:
--------------------------------

    Remaining Estimate: 48h
     Original Estimate: 48h

> SQL std auth - authorize create database
> ----------------------------------------
>
>                 Key: HIVE-5969
>                 URL: https://issues.apache.org/jira/browse/HIVE-5969
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Authorization
>            Reporter: Thejas M Nair
>   Original Estimate: 48h
>  Remaining Estimate: 48h
>
> 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)