Re: 7.4 Alter User xxx VALID UNTIL '2000-01-01' does not work

NEVER MIND.  I found this post:

    http://archives.postgresql.org/pgsql-hackers/2003-03/msg00671.php

Actually I'd found it before but the site was down for a few minutes and so
I couldn't read that page.  The gist is:
    1.  expirations apply to passwords not accounts
    2.  and, of course, passwords aren't check when using non-pw based
connection schemes (e.g., Ident).

== Ezra E.

"ezra epstein" <ee_newsgroup_post@prajnait.com> wrote in message
news:aiKdncTpIY1OHWiiXTWc-g@speakeasy.net...
> I'm trying to keep a user around but make it invalid.  E.g., by setting
the
> valid until to be a time in the past.  I've tried this:
>
>     alter user pw_config valid until 'Jan 31 2001';
>
> and this:
>
>    alter user pw_config valid until '2000-01-01';
>
> and even this:
>
>     alter user pw_config valid until '-infinity';  -- for good measure
>
> and none of them seems to have an affect.  The field is changed (pg_admin
> says so) but psql still lets the user connect and execute statements.
>
> Help!
>
>   == Ezra Epstein
>
>