Currently, I am able to login into my server using Squirrel by just providing the jdbc connection string and username
This way, anybody can connect to Hive.
I want to restrict this and make each user provide their own username along with the password.
Is there a way to achieve this?
I have not setup Kerberos yet but is there anyother way to achieve this without setting up Kerberos?
hive can be configured to authenticate with LDAP/PAM. You need to configure hive authentication as per your environment. Review below doc for more info.