Hi Muthupandi Glad to know it worked for you. Please continue to provide your feedback and also if you have any suggestions to add new features.
Thanks Bosco > On Dec 18, 2014, at 3:13 AM, Muthu Pandi <muthu1...@gmail.com> wrote: > > 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. > > Regards > Muthupandi.K > > Think before you print. > > > > > > > > On Wed, Dec 17, 2014 at 2:43 AM, Don Bosco Durai <bo...@apache.org > <mailto:bo...@apache.org>> 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 <muthu1...@gmail.com >> <mailto:muthu1...@gmail.com>> 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. >> >> Regards >> Muthupandi.K >> >> Think before you print. >> >> >> >> >> >> >