pgAdmin              v 1.16.1

Windows 7 x64

 

PostgreSQL         v9.4.2

CentOS 6.4

 

pgAdmin by default when editing a user's account settings seems  to set
Account Validity to '1969-12-31 00:00:00+01' if the role is defined as valid
until infinity.

This results in the user not being able to login, and only receiving a
password authentication failed error message (Account Expired would be more
helpful, but that's for Postgres ;)).

 

An example would be adding a user to a group role via the Role membership
tab, and never actually opening the Definition tab.

You'd be blissfully unaware that Password validity had been changed.

 

Best regards,

Brett

 

Reply via email to