| 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: | Whole Thread | Raw Message | 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
| 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 |