Re: need authorization in hive

2011-10-20 Thread Alexander C.H. Lorenz
depends on your configuration (metastore). if the user abc exist as a linux user: sudo -u apache hive should work. - Alex On Thu, Oct 20, 2011 at 4:21 PM, Ankit Jain wrote: > > Thanks for reply, > > my problem is still not solve. > > u have any idea about, how we can switch user in hive. > >

Re: need authorization in hive

2011-10-20 Thread Ankit Jain
Thanks for reply, my problem is still not solve. u have any idea about, how we can switch user in hive. Thanks, Ankit On Thu, Oct 20, 2011 at 7:29 PM, Alexander C.H. Lorenz < wget.n...@googlemail.com> wrote: > try to run as user abc: > > REVOKE ALL PRIVILEGES, GRANT OPTION > FROM user [, us

Re: need authorization in hive

2011-10-20 Thread Alexander C.H. Lorenz
try to run as user abc: REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ... https://cwiki.apache.org/confluence/display/Hive/AuthDev#AuthDev-4.3grant%2Frevokestatement - Alex On Thu, Oct 20, 2011 at 3:45 PM, Ankit Jain wrote: > Hi Alexander, > > Thanks for reply.. > > I have used

Re: need authorization in hive

2011-10-20 Thread Ankit Jain
Hi Alexander, Thanks for reply.. I have used the use test_dn and then run the command create table test (one string);. Actual problem is that .. my current user is 'abc' and 'abc' doesn't have permission over test_db database. I have granted all permission to user apache. So, i want to switch

Re: need authorization in hive

2011-10-20 Thread Alexander C.H. Lorenz
Hi, did you use the database: hive> use test_db; hive> create table test (one string); OK Time taken: 0.303 seconds works for me. regards, Alex On Thu, Oct 20, 2011 at 2:50 PM, Ankit Jain wrote: > Hi all, > > I have created database test_db and grant all permission to user 'apache' > on 'tes