Re: [BUG?] Account expire date

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
Cc: PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: [BUG?] Account expire date
Date: 2013-05-09 20:54:34
Message-ID: 1368132874.25473.0.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Wed, 2013-05-08 at 08:52 +0200, Bartosz Dmytrak wrote:
> Hi all,
> On login role properties window, "Definition" tab, there is account expire
> date. Odd thing is that checkbox is checked and date is assigned even when
> there is no valid date set on account.
> Consequence is when you click "OK" button without do anything, then SQL:
>
> ALTER ROLE "MyRole"
> VALID UNTIL '1970-01-01 00:00:00';
>
> is executed, so user would not be able to login again, because account
> expired.
>
> SQL is prepared at very beginning, Simply open "Properties" on login node
> and click "SQL" tab - script is ready to be executed. Works this way for
> roles without validity term.
>

This has been fixed some time ago, but no minor release yet.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

--
Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Yan, Shawn 2013-05-10 07:27:40 pgAdmin enhancement request.
Previous Message Dave Page 2013-05-09 06:02:23 Re: 1.16.1: many operations cause display tree to collapse