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
>>
>>
>>
>
>
>
>
>
