Support Questions

Find answers, ask questions, and share your expertise

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

avatar
Explorer

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 3

avatar
Super Collaborator

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.

avatar
Expert Contributor

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

avatar
Super Collaborator

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