Re: bug report role properties expiration date

Hi David,

This issue has been fixed. I believe, the next latest installer will be
having this fix.

commitID: 3dfa02a90bfa5202c305187cf90baea1b46f6240.

Dinesh

--
*Dinesh Kumar*
Software Engineer

Ph: +918087463317
Skype ID: dinesh.kumar432
www.enterprisedb.co
<http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>

*Follow us on Twitter*
@EnterpriseDB

Visit EnterpriseDB for tutorials, webinars,
whitepapers<http://www.enterprisedb.com/resources-community> and
more <http://www.enterprisedb.com/resources-community>

On Sun, Feb 23, 2014 at 1:41 AM, David Elbert <elbert(at)jhu(dot)edu> wrote:

> Hi-
>
> If I understand the help, I am to make a bug report by email to this list.
> If not, I apologize. I also am not sure if attached screenshots will work
> with a mailing list, but I'm adding them with the hope they will. (If I
> need to do this another way, I'd appreciate a clarification.)
>
> I am getting unexpected behavior from pgAdmin3; Here is the basic
> information:
>
> 1. pgAdmin3 Macintosh version 1.18.1 binary download from
> http://www.pgadmin.org/download/macosx.php
> 2. Macintosh OS X v.10.6.8 ("Snow Leopard")
> 3. connecting to PostgreSQL 9.3.1 on Amazon Web Services RDS
>
> Description of problem:
>
> 1. Start with a Login Role with no "VALID UNTIL" expiration set.
> 2. Open "Properties" window in pgAdmin3 and look at "Definition" tab.
> 3. pgAdmin3 fills in current date for "Account expires" field. There is no
> user action asking for this. It is done automatically and is clearly not a
> desired behavior since it will cause login ability to expire unexpectedly
> if user uses "OK" button rather than "Cancel" to exit "Properties."
> 4. NOTE: this automatic filling of the "Account expires" field happens
> even if the user never selects the "Definition" tab. That means that when
> a user opens the Properties box for a role just to look at things and hits
> "OK" even without making any changes, the expiration will be set!
>
> Attached screenshot show open "Properties" window with offending "Account
> expires" field with today's date. Also shows SQL panel behind showing that
> there is no "VALID UNTIL" property on the selected user.
>
> Second screenshot shows that after exiting with "OK" button the account
> expiration date is added to the user's role.
>
> Resolution should be that the "Account expires" field should remain empty
> unless a user specifically adds a value. (It also might be nice to have an
> "idiot" window check that the user really wants the filled in date if it
> happens to be the current date, but that is a matter of opinion.)
>
> Thanks,
> David
>
>
>
> David Elbert
> Associate Program Director for Environmental Studies,
> Advanced Academic Programs &
> Earth and Planetary Sciences
> Olin Hall
> Johns Hopkins University
> 3400 N. Charles St
> Baltimore, MD 21218
>
> (410) 516-5049
>
> elbert(at)jhu(dot)edu
>
>
>
>
>
>