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---
