Request a Demo
Home   >   mailing lists

Re: Can we lock or expire a ROLE / USER - Mailing list pgsql-novice

From David G. Johnston
Subject Re: Can we lock or expire a ROLE / USER
Date
Msg-id CAKFQuwYJyzos9OXJy3ET+iAsyRRD-acmFvXdH5+0EY0XLMiOhQ@mail.gmail.com
Whole thread Raw
In response to Can we lock or expire a ROLE / USER  ("Subramanian,Ramachandran" <ramachandran.subramanian@alte-leipziger.de>)
List pgsql-novice
Tree view
On Friday, September 19, 2025, Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de> wrote:

Is it possible to LOCK or DEACTIVATE or EXPIRE a USER ( ROLE with LOGIN ) after

  1. A set period of inactivity
  2. 5 Wrong password attempts 

I searched through the manals and did not find any mention of such a facility.

And thus it does not exist, at least in core.  Not sure what is available in the world of extensions.

Otherwise you’d want to log login events and you could then script a tool to alter role upon seeing relevant log activity.

David J.

pgsql-novice by date:

Previous
From: "Subramanian,Ramachandran"
Date:
Subject: Can we lock or expire a ROLE / USER
Next
From: Laurenz Albe
Date:
Subject: Re: Can we lock or expire a ROLE / USER