By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,852 Members | 2,200 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,852 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
NEVER MIND. I found this post:

http://archives.postgresql.org/pgsql...3/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***************@prajnait.com> wrote in message
news:ai********************@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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.