7.4 Alter User xxx VALID UNTIL '2000-01-01' does not work - Mailing list pgsql-general

From ezra epstein
Subject 7.4 Alter User xxx VALID UNTIL '2000-01-01' does not work
Date
Msg-id aiKdncTpIY1OHWiiXTWc-g@speakeasy.net
Whole thread Raw
List pgsql-general
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



pgsql-general by date:

Previous
From: "ezra epstein"
Date:
Subject: Re: 7.4 ERROR: CREATE LOCAL TEMPORARY TABLE ... ON COMMIT DROP inside a function
Next
From: "ezra epstein"
Date:
Subject: Any way to have CREATEUSER privs without having all privs?