hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Navis류승우 <navis....@nexr.com>
Subject Re: Help on restricting users
Date Mon, 21 Jul 2014 04:23:58 GMT
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