Re: Security for Hive

2013-02-23 Thread Owen O'Malley
Correct, you'll need to manage the permissions manually in HDFS. The authorization model in Hive is just to prevent accidents. Hopefully, we'll address this eventually, but in the mean time it is strongly encouraged to set the permissions of your databases and tables in hdfs to the desired permissi

RE: Security for Hive

2013-02-23 Thread Austin Chungath
Thanks Bejoy. Sent from my Windows Phone -- From: bejoy...@yahoo.com Sent: 23-02-2013 08:29 PM To: user@hive.apache.org Subject: Re: Security for Hive Hi Austin AFAIK at the moment you can control permissions gracefully only on a data level not on the metadata

Re: Security for Hive

2013-02-23 Thread bejoy_ks
2013 23:11:51 To: bejoy...@yahoo.com; user@hive.apache.org Reply-To: user@hive.apache.org Subject: RE: Security for Hive So that means any user can revoke or give permissions to any user for any table in the metastore? Sent from my Phone, please ignore typos -- From

RE: Security for Hive

2013-02-22 Thread Austin Chungath
So that means any user can revoke or give permissions to any user for any table in the metastore? Sent from my Phone, please ignore typos -- From: bejoy...@yahoo.com Sent: 22-02-2013 11:30 PM To: user@hive.apache.org Subject: Re: Security for Hive Hi Sachin

Re: Security for Hive

2013-02-22 Thread bejoy_ks
Hi Sachin Currently there is no such admin user concept in hive. Regards Bejoy KS Sent from remote device, Please excuse typos -Original Message- From: Sachin Sudarshana Date: Fri, 22 Feb 2013 16:40:49 To: Reply-To: user@hive.apache.org Subject: Re: Security for Hive Hi, I have

Re: Security for Hive

2013-02-22 Thread Sachin Sudarshana
Hi, I have read about roles, user privileges, group privileges etc. But these roles can be created by any user for any database/table. I would like to know if there is a specific 'administrator' for hive who can log on with his credentials and is the only one entitled to create roles, grant privile

Re: Security for Hive

2013-02-22 Thread Jagat Singh
You might want to read this https://cwiki.apache.org/Hive/languagemanual-auth.html On Fri, Feb 22, 2013 at 9:44 PM, Sachin Sudarshana < sachin.sudarsh...@gmail.com> wrote: > Hi, > > I have just started learning about hive. > I have configured Hive to use mysql as the metastore instead of derby