Guidance on user deletion - Mailing list pgsql-admin

From Wetmore, Matthew (CTR)
Subject Guidance on user deletion
Date
Msg-id f77fac58f3094867b9edc9a10904008f@evernorth.com
Whole thread Raw
Responses Re: Guidance on user deletion
Re: Guidance on user deletion
List 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?

 

 

pgsql-admin by date:

Previous
From: Keith Fiske
Date:
Subject: Re: Adding future partition causes deadlock???
Next
From: Chris Hoover
Date:
Subject: Re: Adding future partition causes deadlock???