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

From: "ezra epstein" <ee_newsgroup_post(at)prajnait(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 7.4 Alter User xxx VALID UNTIL '2000-01-01' does not work
Date: 2004-01-02 14:50:56
Message-ID: aiKdncTpIY1OHWiiXTWc-g@speakeasy.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-01-02 14:53:37 Re: pull_up_subqueries question
Previous Message Dennis Haney 2004-01-02 13:46:55 pull_up_subqueries question