For example, say /apps/hive/warehouse/my_database.db has changed from 777 permissions to 750 for user my_user and group my_group. Assume too that no Hive roles were set. Would another_user, who is outside my_group, still be able to query the Hive database?
Have you tried accessing it that way ? The mapping for DB access is maintained in metadata so not sure how it reflects on access if you change things at HDFS layer.
Same, I'm not sure how it reflects on access Hive-wise if i change permissions on HDFS.. I'm asking this in light of an environment that I don't have admin privileges to, but I guess I can try it on the sandbox