You could use SASL / kerberos implementation within HiveServer2. Depends on a kerberosized cluster, too. Hive's metastore server provides the same mechanism, but isn't fully multi connect ready.
Here's a link:
On Nov 22, 2012, at 7:46 AM, Austin Chungath <[EMAIL PROTECTED]> wrote:
> I had been trying to set up a multi user environment for hive.
> I have set up the hive metastore db in MySQL and hive works.
> Consider this scenario:
> user1 has created a database data1
> user2 has created a database data2
> Now user2 logs into hive and he is able to see and delete database data2
> How do I prevent this?
German Hadoop LinkedIn Group: http://goo.gl/N8pCF