Skip to main content
JiHoone
Silver ⭐️⭐️
August 12, 2024
Question

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

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.

JiHoone_0-1723423279266.png

 

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

JiHoone_1-1723425204586.png

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

 

This is a ODBC setting for connecting to Hive.

JiHoone_2-1723425350628.png

 

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

JiHoone_3-1723425459082.png

JiHoone_4-1723425515548.png

JiHoone_5-1723425639703.png

 

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.

 

 

3 replies

ggangadharan
Gold ⭐️
Gold ⭐️
August 28, 2024

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.

Translate
vamsi_redd
Gold ⭐️
Gold ⭐️
September 1, 2024

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

Translate
tj2007
Gold ⭐️⭐️
Gold ⭐️⭐️
September 5, 2024

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

Translate