hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sai chaitanya tirumerla <tirume...@gmail.com>
Subject Re: Help on restricting users
Date Mon, 21 Jul 2014 19:12:41 GMT
Hi Navis,

Thank you so much for the information.I'm newbie to hooks in hive , could
you please let me know how we can implement hooks for restricting users and
do we have any reference/examples to look at.

Thanks,

Sai


On Sun, Jul 20, 2014 at 9:23 PM, Navis류승우 <navis.ryu@nexr.com> wrote:

> You can implement that in Hook and register in hive-site.xml.
>
> Thanks,
> Navis
>
>
> 2014-07-19 17:32 GMT+09:00 sai chaitanya tirumerla <tirumerla@gmail.com>:
>
> Hi,
>>
>> I would like to restrict users doing
>> "select * from table;" when accessed from any jdbc/odbc tools like sql
>> workbench/excel etc.. connecting to hiveserver2 on port 10000. I am able to
>> successfully restrict users from running mapreduce jobs like "select
>> count(*) from table" by changing permissions on tmp directory on hdfs
>> allowing only certain users to access.
>> I have tried using SQL based authorization but it is introduced in hive
>> 0.13 and the version i am currently on is hive 0.11.
>> I have also tried using hive client authorization which works only for
>> hive cli but not hiveserver2 when connected from jdbc/odbc tools as the
>> connection is done via the default user.
>>
>> So is there any way that we can restrict users accessing the data (
>> select * from table )?
>>
>> Thanks in Advance!!
>>
>> ---sai---
>>
>
>

Mime
View raw message