You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Sachin Sudarshana <sa...@gmail.com> on 2013/02/22 11:44:51 UTC
Security for Hive
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
Re: Security for Hive
Posted by be...@yahoo.com.
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 <sa...@gmail.com>
Date: Fri, 22 Feb 2013 16:40:49
To: <us...@hive.apache.org>
Reply-To: 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 <ja...@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.sudarshana@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
Re: Security for Hive
Posted by Sachin Sudarshana <sa...@gmail.com>.
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 <ja...@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.sudarshana@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
Re: Security for Hive
Posted by Jagat Singh <ja...@gmail.com>.
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.sudarshana@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
>