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 >>>> >>>> >>>> >>> >>> >>> >>> >>> >> > > > -- > Alexander C.H. Lorenz > Dieterlestraße 56 > D - 70469 Stuttgart > > GULP <http://www.gulp.de/Profil/hadoopAdmin.html> | > XING<http://www.xing.com/profile/CurtHerbert_Lorenz> > > > >
