Redshift change user password from workbench/j

Asked Dec 05 '17 at 16:43

Active Dec 05 '17 at 16:43

Viewed 1,919 times

I have a weird problem when trying to change Redshift user password using SQL workbench/j.

Here is the command I am running: alter user someUser password 'someNewPassword';

It returns response "ALTER USER someUser successful"

However, when I try to login with the new password it fails, while the old password still works. Does anyone know why this could happen?

asked Dec 05 '17 at 16:43

Tofig Hasanov

5

Did you `commit` the `ALTER USER` statement? – Dec 05 '17 at 17:08
@a_horse_with_no_name Thanks! That was the issue. Stupid me! – Tofig Hasanov Dec 05 '17 at 18:23

0 Answers0