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.