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>
