Hi Austin AFAIK at the moment you can control permissions gracefully only on a data level not on the metadata level. ie you can play with the hdfs permissions .
Regards Bejoy KS Sent from remote device, Please excuse typos -----Original Message----- From: Austin Chungath <austi...@gmail.com> Date: Fri, 22 Feb 2013 23:11:51 To: bejoy...@yahoo.com<bejoy...@yahoo.com>; user@hive.apache.org<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: bejoy...@yahoo.com Sent: 22-02-2013 11:30 PM To: user@hive.apache.org Subject: Re: Security for Hive Hi Sachin Currently there is no such admin user concept in hive. Regards Bejoy KS Sent from remote device, Please excuse typos ------------------------------ *From: * Sachin Sudarshana <sachin.sudarsh...@gmail.com> *Date: *Fri, 22 Feb 2013 16:40:49 +0530 *To: *<user@hive.apache.org> *ReplyTo: * user@hive.apache.org *Subject: *Re: Security for Hive 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 privileges etc. Thank you. On Fri, Feb 22, 2013 at 4:19 PM, Jagat Singh <jagatsi...@gmail.com> wrote: > 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. >> If I wish to use GRANT and REVOKE commands, i can use it with any user. A >> user can issue GRANT or REVOKE commands to any other users' table since >> both the users' tables are present in the same warehouse. >> >> Isn't there a concept of superuser/admin in hive who alone has the >> authority to issue these commands ? >> >> Any answer is greatly appreciated! >> >> -- >> Thanks and Regards, >> Sachin Sudarshana >> > > -- Thanks and Regards, Sachin Sudarshana