hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <leftylever...@gmail.com>
Subject Re: question on create database
Date Thu, 02 Apr 2015 20:55:50 GMT
Could you use SQL standards based authorization to deny CREATE TABLE
privileges to everybody except the database owner, and then make people ask
the owner to create tables for them?

-- Lefty

On Thu, Apr 2, 2015 at 4:44 PM, Chen Song <chen.song.82@gmail.com> wrote:

> Got it. Thanks.
>
> On Thu, Apr 2, 2015 at 11:29 AM, Alan Gates <alanfgates@gmail.com> wrote:
>
>> When someone creates a table in your 'abc' database it should by default
>> be in '/my/preferred/directory/_tablename_'.  However, users can specify
>> locations for their tables which may not be in that directory.  AFAIK
>> there's no way to prevent that.
>>
>> Alan.
>>
>>   Chen Song <chen.song.82@gmail.com>
>>  April 2, 2015 at 8:15
>> I have a dumb question on DDL statement "create database"
>>
>> Say if I create a database
>> CREATE DATABASE abc
>> LOCATION '/my/preferred/directory';
>> When later on someone needs to create a table in this database, is there
>> a way to force the location of the table to be under
>> /my/preferred/directory?
>>
>> I searched around but could not find a way to enforce this.
>>
>>
>> --
>> Chen Song
>>
>>
>
>
> --
> Chen Song
>
>

Mime
View raw message