Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Highlighted

[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
Highlighted

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

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.

Highlighted

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

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

Don't have an account?
Coming from Hortonworks? Activate your account here