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?