| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | "Subramanian,Ramachandran" <ramachandran(dot)subramanian(at)alte-leipziger(dot)de> |
| Cc: | "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Can we lock or expire a ROLE / USER |
| Date: | 2025-09-19 13:57:28 |
| Message-ID: | CAKFQuwYJyzos9OXJy3ET+iAsyRRD-acmFvXdH5+0EY0XLMiOhQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Friday, September 19, 2025, Subramanian,Ramachandran <
ramachandran(dot)subramanian(at)alte-leipziger(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2025-09-19 15:55:16 | Re: Can we lock or expire a ROLE / USER |
| Previous Message | Subramanian,Ramachandran | 2025-09-19 08:32:33 | Can we lock or expire a ROLE / USER |