Re: ALTER USER - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ALTER USER
Date
Msg-id 5842.1047910794@sss.pgh.pa.us
Whole thread Raw
In response to Re: ALTER USER  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-hackers
Bruno Wolff III <bruno@wolff.to> writes:
> Is it just the password that expires or the account? The comment for
> valid until says the password is valid until that time. However, one of
> the examples says the account is valid until that time.

Given the current implementation, I think it's correct to say that
the password expires not the account:

1. the userid isn't deleted or anything like that.

2. validuntil is only checked in password authentication methods; if you
are able to connect via a non-password auth method (eg IDENT) then it's
not checked.

I've never been quite sure whether #2 is a bug or a feature, though.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: transaction abort
Next
From: "Peter Galbavy"
Date:
Subject: Re: ALTER USER