Message-ID: <3ba7717e5493f3c3b45127457f540b7811f6f6e1.camel@j-davis.com>
Subject: Re: [PoC/RFC] Multiple passwords, interval expirations
From: Jeff Davis <pgsql@j-davis.com>
To: Gurjeet Singh <gurjeet@singh.im>
Cc: Nathan Bossart <nathandbossart@gmail.com>, PostgreSQL Hackers
 <pgsql-hackers@lists.postgresql.org>, Stephen Frost <sfrost@snowman.net>, 
 "Brindle, Joshua" <joshuqbr@amazon.com>, Jacob Champion
 <jchampion@timescale.com>
Date: Fri, 06 Oct 2023 13:29:24 -0700
In-Reply-To: <CABwTF4Xm97B3d2OkVWWpS1GBrRY_zJY8bkmQzmzYnXM0NU3w5Q@mail.gmail.com>
References: 
	<CAGB+Vh5Ed65gCmjJxCYguVoBoiDLePYDAeHMkb6-7PR-DFU-yQ@mail.gmail.com>
	 <b951f0c9-b568-4889-8418-b01cf5a3cea2@timescale.com>
	 <CAOuzzgpyFRFbskZW0uYwP4_r5NkFJywTurn0SQ+pkbcuuQchjw@mail.gmail.com>
	 <CABwTF4Uih+xKc8o7W-Qmzo2Oc3BbvnY+JHzcZ-HG2vDzBQpf8w@mail.gmail.com>
	 <20220701002034.GA9030@tamriel.snowman.net>
	 <80684017-18c6-4116-9249-bb049ffe1ecf@amazon.com>
	 <CAOuzzgq2j43X6vwF8LCPcPuKZ2gw0ZbF=CrsB6CmtEt1h2ci0g@mail.gmail.com>
	 <CABwTF4XZO_429=QzZHt-1Q=KSCR2XjYG+xVy2p-PdPtun9tVdg@mail.gmail.com>
	 <41a690ee7b030e6f41709bd39375641ef934e05f.camel@j-davis.com>
	 <CABwTF4Xf5qJgeapUvT3fbU+Er9sVKBEihcj7pb9_A4c5u1NaZA@mail.gmail.com>
	 <20231005190453.GB151257@nathanxps13>
	 <2644f1886c7f5e2691f837de138ac5c3a09a68f6.camel@j-davis.com>
	 <CABwTF4Xm97B3d2OkVWWpS1GBrRY_zJY8bkmQzmzYnXM0NU3w5Q@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.44.4-0ubuntu2 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/3ba7717e5493f3c3b45127457f540b7811f6f6e1.camel%40j-davis.com>
Precedence: bulk

On Thu, 2023-10-05 at 14:28 -0700, Gurjeet Singh wrote:

> This way there's a notion of a 'new' and 'old' passwords.

IIUC, you are proposing that there are exactly two slots, NEW and OLD.
When adding a password, OLD must be unset and it moves NEW to OLD, and
adds the new password in NEW. DROP only works on OLD. Is that right?

It's close to the idea of deprecation, except that adding a new
password implicitly deprecates the existing one. I'm not sure about
that -- it could be confusing.

We could also try using a verb like "expire" that could be coupled with
a date, and that way all old passwords would always have some validity
period. That might make it a bit easier to manage if we do need more
than two passwords.

Regards,
	Jeff Davis