Postgres Aurora RDS password auth fails except with master user I can successfully connect to a Postgres Aurora server using the master password thru the SSH tunnel on the bastion host I have setup.

However, when I create any other users, I can't connect with them even tho all other things are the same configuration wise. I get a DB level auth error.

password authentication failed for user "SomeUser"


I've added the users using these queries.

CREATE USER SomeUser LOGIN ENCRYPTED PASSWORD 'SoMePaSsWoRd';
GRANT CONNECT ON DATABASE postgres TO SomeUser;
ALTER USER SomeUser CREATEDB;
GRANT ALL PRIVILEGES ON DATABASE postgres TO SomeUser;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO SomeUser;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO SomeUser;


What am I missing here?
Even tho PG is case sensitive in other cases, it requires lowercase usernames. Using a lower case name during login fixed the issue.