Re: Guidance on user deletion

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Sun, May 12, 2024 at 6:56 AM vrms <vrms@xxxxxxxxxxxxx> wrote:

The five account systems I've had experience with (OpenVMS, Linux, Active Directory, SQL Server, Postgresql) all have the ability to expire users, and to unexpire them if the person ever returns.

how do you practically expire an account in postgres?

ALTER ROLE ... VALID UNTIL 'timestamp';