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