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 13:45:38 GMT
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
>>
>>
>>
>
>
>
>
>

Mime
View raw message