Обсуждение: [BUG?] Account expire date
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';
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.
Regards,
Bartek
Bartek
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