Re: Can we lock or expire a ROLE / USER

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Can we lock or expire a ROLE / USER
Дата
Msg-id CAKFQuwYJyzos9OXJy3ET+iAsyRRD-acmFvXdH5+0EY0XLMiOhQ@mail.gmail.com
обсуждение исходный текст
Ответ на Can we lock or expire a ROLE / USER  ("Subramanian,Ramachandran" <ramachandran.subramanian@alte-leipziger.de>)
Список pgsql-novice
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 по дате отправления: