hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Jain <ankitjainc...@gmail.com>
Subject Re: need authorization in hive
Date Thu, 20 Oct 2011 14:21:20 GMT
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.null@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 <ankitjaincs06@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.null@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 <ankitjaincs06@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>
>
>
>
>

Mime
View raw message