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:
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