Support Questions
Find answers, ask questions, and share your expertise

[Hive] Do the .db files' permissions affect who can access the Hive databases?

New Contributor

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?

2 REPLIES 2

Guru

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.

New Contributor

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