[jira] [Commented] (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:comment-tabpanel&focusedCommentId=13981679#comment-13981679 ] 

Thejas M Nair commented on HIVE-5969:
-------------------------------------

Regarding the statement in description:
bq. and if the database is owned by a role (rather than a user) the directory must be
owned by the hive user.

The create database statement does not allow specifying the owner role. So this is not currently applicable.
The ownership can be changed to another using or role only using admin role privileges.


> 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)