Username is case sensitive after client authentication record is created
After creating a client authentication record, user cannot log in if the user provides correct username but with different case.
CREATE USER Test_user IDENTIFIED BY 'pass';
Without client authentrication record, the user can login usnig case-insensitive username.
However, after creating auth record, the user can login only if the username is provided as "Test_user" but not as "test_user" or so on.
I had created auth record as below-
CREATE AUTHENTICATION auth_pwd METHOD 'hash' LOCAL;
GRANT auth_pwd TO test_user;
Is there any way to make username case insensitivie when auth record is active?
Thanks,
Rupendra
0
Comments
Hi Rupendra,
Thanks for contributing to the community. I'm looking into this issue now and will get back to you when I have more information.
-Vicki
HP Vertica Information Development
Hi
I just tested this on 7.2 and it is working.
vsql -d v720 -h hostname -U Test
vsql -d v720 -h hostname -U TEST
vsql -d v720 -h hostname -U test
all work fine.
What authentication method is your user using? Please provide details.
Thanks
Gayatri
I am facing the same issue. Was there any solution for this?
There is no issue...
Connection through VSQL works fine in 7.x version but fails in 8.x version. When tested with any other SQL Client like Squirrel it fails in both 7.x and 8.x versions
Hi,
I performed my test above on Vertica 9.1.
Here is a test with 8.1.1-16:
So there is an issue with 8.1.x.
I will open a ticket on this and keep this thread updated.
Thanks!
@udaymatampusala - Vertica strongly recommends that you use SHA-512 for hash authentication because it is more secure than MD5.
If I switch the “Hash Authentication” for the user I tested in the previous posts in this thread to “SHA512”, I can log in as a case-insensitive user:
Example:
See:
https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/Security/ClientAuth/ConfiguringHashAuthentication.htm