Guidance on user deletion

From: "Wetmore, Matthew (CTR)" <Matthew(dot)Wetmore(at)evernorth(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Guidance on user deletion
Date: 2024-05-10 15:13:24
Message-ID: f77fac58f3094867b9edc9a10904008f@evernorth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Corporate env.

I've searched for an official BestPractice on user deletion (leave company), but can't find anything that is official-ish.

Two options:

1. Change user psswd to nonsense, then expire account.
2. DROP user.

There are +/- to both.

I prefer #1, as it gives the exact timestamp of expire (protects company and ex-employee), but corporate auditors disagree.

What do you do? Any official guidance on this?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2024-05-10 15:34:03 Re: Adding future partition causes deadlock???
Previous Message Keith Fiske 2024-05-10 15:05:45 Re: Adding future partition causes deadlock???