Обсуждение: Password Expiry

<div class="WordSection1"><p class="MsoNormal">pgAdmin              v 1.16.1<p class="MsoNormal">Windows 7 x64<p
class="MsoNormal"> <pclass="MsoNormal">PostgreSQL         v9.4.2<p class="MsoNormal">CentOS 6.4<p class="MsoNormal"> <p
class="MsoNormal">pgAdminby default when editing a user’s account settings seems  to set Account Validity to
‘1969-12-3100:00:00+01’ if the role is defined as valid until infinity.<p class="MsoNormal">This results in the user
notbeing able to login, and only receiving a password authentication failed error message (Account Expired would be
morehelpful, but that’s for Postgres ;)).<p class="MsoNormal"> <p class="MsoNormal">An example would be adding a user
toa group role via the Role membership tab, and never actually opening the Definition tab.<p class="MsoNormal">You’d be
blissfullyunaware that Password validity had been changed.<p class="MsoNormal"> <p class="MsoNormal">Best regards,<p
class="MsoNormal">Brett<pclass="MsoNormal"> </div> 

Hi

On Wed, Apr 10, 2013 at 12:31 PM, Brett Maton <matonb@ltresources.co.uk> wrote:
> 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.

This has been fixed already for future releases:

commit 265143d8134a5d191ad6db1162a9408f23c185c7
Author: Dave Page <dpage@pgadmin.org>
Date:   Wed Feb 6 15:24:50 2013 +0000
   Fix expiry date handling for users.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company