Yes, you are right! Toad (at least my version) does not give an option to specific user/password.
Is there any other way (may be using other SQL editors) that we can enforce user id/password on Hive? Also how do we set up users on hive? Regards, Shantian ________________________________ From: Amit Sharma <amitsharma1...@gmail.com> To: user@hive.apache.org Cc: Shantian Purkad <shantian_pur...@yahoo.com> Sent: Tuesday, January 31, 2012 11:55 AM Subject: Re: Hive Security Toad uses JDBC only while connecting as a direct Hive Connection from Eclipse. In most other cases where a Hub is involved it uses Thrift. On the other hand in the current release of Toad for Cloud there is no way to specify what hive user you want to connect as and hence it always connects as the User with which the hive server is running, and connects to the default database. What version of Toad for Cloud are you using? Thanks, Amit On Tue, Jan 31, 2012 at 10:59 AM, Sriram Krishnan <skrish...@netflix.com> wrote: I was under the impression that Toad uses JDBC – and AFAIK there is no way to authenticate users via JDBC using the HiveServer. > > >FYI - https://issues.apache.org/jira/browse/HIVE-2539. > > >BTW if anyone has a solution to this, I would be very interested to know as >well. > > >Sriram > >From: Shantian Purkad <shantian_pur...@yahoo.com> >Reply-To: <user@hive.apache.org>, Shantian Purkad <shantian_pur...@yahoo.com> >Date: Tue, 31 Jan 2012 10:20:04 -0800 >To: "user@hive.apache.org" <user@hive.apache.org> >Subject: Hive Security > > > >Hi, > > >We are running Hive server and connecting to it through Toad. Everything works >fine. > > >Now we want to enable authentication on the hive server. The hive server >indicates that we can specify user id password while connecting to it. > > >Can someone please guide on how can we create and set users on hive server? > > > > > >Regards, >Shantian
