Re: Guidance on user deletion

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: vrms <vrms(at)netcologne(dot)de>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Guidance on user deletion
Date: 2024-05-12 13:20:25
Message-ID: CANzqJaA0zyFkTPLQwRLKNE5jVCM5QXjw-eA3V9TiQy4DHA-byg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, May 12, 2024 at 6:56 AM vrms <vrms(at)netcologne(dot)de> 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';

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wasim Devale 2024-05-12 13:33:03 Postgis
Previous Message vrms 2024-05-12 10:56:33 Re: Guidance on user deletion