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