RE: question on create database

2015-04-02 Thread Mich Talebzadeh
[mailto:leftylever...@gmail.com] Sent: 02 April 2015 21:56 To: user@hive.apache.org Subject: Re: question on create database 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

Re: question on create database

2015-04-02 Thread Lefty Leverenz
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 wrote: > Got it. Thanks. > > On Thu, Apr 2, 2015 at 11:29 AM,

Re: question on create database

2015-04-02 Thread Chen Song
Got it. Thanks. On Thu, Apr 2, 2015 at 11:29 AM, Alan Gates 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

Re: question on create database

2015-04-02 Thread Alan Gates
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