Created 07-03-2018 04:52 AM
Created 07-03-2018 05:22 AM
Do you have hive ranger plugin enabled? If so, give yourself access to that DB.
Created 07-03-2018 06:42 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:
Created 07-03-2018 07:58 AM
@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.
Created 07-03-2018 05:11 PM
Have you set one ranger instance for multi clusters? Did I understand you with this statement "I have login on cluster2 and it shows all the DBs from cluster1 and from cluter2."
Can you explain your setup.