hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander C.H. Lorenz" <wget.n...@googlemail.com>
Subject Re: need authorization in hive
Date Thu, 20 Oct 2011 14:31:05 GMT
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 <ankitjaincs06@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.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
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>

Mime
View raw message