Yes you are right i had done mistake by not configuring hive repository correctly, after configuring hive repository and its name it use the ranger authorization.
Great work Guys, Authorization look simple and effective. *RegardsMuthupandi.K* Think before you print. On Wed, Dec 17, 2014 at 2:43 AM, Don Bosco Durai <[email protected]> wrote: > > Hi Muthupandi > > At an high level, it seems Hive is still using it’s native authorization. > Can you check the Audit in Ranger to see whether Ranger is auditing it? > > Thanks > > Bosco > > > > On Dec 15, 2014, at 9:19 PM, Muthu Pandi <[email protected]> wrote: > > Hi All > > I have configured Ranger on Hadoop 2.6.0 and Hive 0.14 and set up > users and policies. > > When i try to test the scenario using the ODBC i got exception as > > Driver Version: V1.1.0.0 > > Running connectivity tests... > > Attempting connection > Failed to establish connection > SQLSTATE: HY000[Microsoft][HiveODBC] (68) Error returned trying to set > default as the initial database: Error while compiling statement: FAILED: > HiveAccessControlException Permission denied: user [ami] does not have > [USE] privilege on [default]; Also tried quoting the database name > `default` but the query failed with the following error: Error while > compiling statement: FAILED: HiveAccessControlException Permission denied: > user [ami] does not have [USE] privilege on [default] > > TESTS COMPLETED WITH ERROR. > > > It clearly states that the user doesn't have privilege for USE command in > hive. While configuring user permission i can able to see different > permissions like select,update,create,drop etc., but not USE. > > Kindly point me in direction where am missing. > > > > *RegardsMuthupandi.K* > > Think before you print. > > > > > > >
