[BUG?] Account expire date

From: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
To: PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: [BUG?] Account expire date
Date: 2013-05-08 06:52:32
Message-ID: CAD8_Ucbk7RzVTXcT4qF_Pidg7_6ximR=3kgekNBTorjEWa6LOg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

Regards,
Bartek

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message David Blaymires 2013-05-08 09:09:01 pgAgent v3.3 job running vacuumdb command fails
Previous Message Dave Page 2013-05-07 08:07:58 Re: Grants on sequences via Grant Wizard