Created 07-03-2018 04:52 AM
Adding to Sunil's reply, when using Hive Cli, the Ranger authorization is by-passed and only storage level authorization is checked for the user against the Hive warehouse locations. When accessing through Beeline, Hiveserver2 honours the Ranger authorization set at Hive policies, hence only databases with select/use access for that user are displayed.
For more details, refer below links:
@Sindhu I have create a policy for all DB,all tables,all columns and gave access to the user, still I can't see the DB. There is DB list but that list is from another cluster. I have login on cluster2 and it shows all the DBs from cluster1 and from cluter2.
Can you explain your setup.