question Re: Why can I see all hive databases without permissions when I connected to Hive by using ODBC. in Support Questions

Why can I see all hive databases without permissions when I connected to Hive by using ODBC.

JiHoone — Mon, 12 Aug 2024 01:22:21 GMT

Hi,

I'm trying to use PowerBI to analyze my Hive data.

But when I'm connecting to Hive by using ODBC, I can see all databases even if I don't have right permissions for other databases.

These are the databases I have permissions in Ranger.

This is a PowerBi screenshot when I connected Hive by using ODBC.

As you can see above, I can see all databases.

This is a ODBC setting for connecting to Hive.

But if I connect to Hive by using HiveLLAP, I can see right databases like below.

So question is

Why can I see all hive databases without permissions when I connected to Hive by using ODBC.

If anyone knows the reason, please let me know.

I would really appreciate it.

Thanks.

Re: Why can I see all hive databases without permissions when I connected to Hive by using ODBC.

ggangadharan — Wed, 28 Aug 2024 07:45:19 GMT

When connecting through ODBC, make sure that Ranger is enabled on the connected HiveServer2 (HS2). If possible, validate the configuration with LLAP for further verification.

Re: Why can I see all hive databases without permissions when I connected to Hive by using ODBC.

vamsi_redd — Sun, 01 Sep 2024 16:01:59 GMT

Please check in the ranger audits what is the user getting authorized when you are seeing the tables through ODBC.

Re: Why can I see all hive databases without permissions when I connected to Hive by using ODBC.

tj2007 — Thu, 05 Sep 2024 08:36:23 GMT

Are you using the same user account to connect via ODBC which you used to log in to Hue? Please verify that.