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

[#1]

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.

[#2]

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.

[#3]

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

[#4]

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