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 <ankitjainc...@gmail.com> wrote: > > 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 [, 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 <ankitjainc...@gmail.com>wrote: >> >>> 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 the user from abc to apache. >>> >>> Thanks, >>> Ankit Jain >>> >>> >>> On Thu, Oct 20, 2011 at 7:07 PM, Alexander C.H. Lorenz < >>> wget.n...@googlemail.com> wrote: >>> >>>> 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 <ankitjainc...@gmail.com>wrote: >>>> >>>>> Hi all, >>>>> >>>>> I have created database test_db and grant all permission to user >>>>> 'apache' on 'test_db' >>>>> hive>create database test_db >>>>> hive>grant all on database test_db to user apache. >>>>> >>>>> hive>show grant user apache on database test_db; >>>>> OK >>>>> database test >>>>> principalName *apache* >>>>> principalType USER >>>>> privilege All >>>>> grantTime 1319111980 >>>>> grantor *abc* >>>>> * >>>>> My current user is 'abc'* >>>>> >>>>> I can't able to create table inside test_db. >>>>> >>>>> I got the following error. >>>>> Authorization failed:No privilege 'Create' found for outputs { >>>>> database:test_db}. Use show grant to get more details. >>>>> >>>>> I have to switch user from 'abc' to 'apache'. Is it possible in hive? >>>>> >>>>> Thanks, >>>>> Ankit >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> >>>> >>>
