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 users' password in SQLStdAuth mode

Hive users' password in SQLStdAuth mode

Rising Star

Hello,

This question can be trivial but I am stuck at it when enabling SQLStdAuth.

I have enabled SQLStdAuth in Hive config in Ambari.

Then i followed this article:

https://community.hortonworks.com/content/supportkb/48940/how-to-setup-sql-based-authorization-in-hi...

However if i create a connection with the username that i set admin role without providing any password, i was able to drop a table after setting current role to admin. Saying that, having only the username but not the password is enough. The username that i have set admin role is an OS user that i created. Am i missing that part? With which layer or component does hive check user's password in jdbc connection? Or is this the expected behaviour and there is no password check?

Thanks in advance

1 REPLY 1

Re: Hive users' password in SQLStdAuth mode

Rising Star

Follow up...