[
https://issues.apache.org/jira/browse/HIVE-5969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thejas M Nair reassigned HIVE-5969:
-----------------------------------
Assignee: Thejas M Nair
> 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
> Assignee: 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.2#6252)
