Re: Locking out a user after several failed login attempts

Поиск
Список
Период
Сортировка
От Jean-Yves F. Barbier
Тема Re: Locking out a user after several failed login attempts
Дата
Msg-id 20110629161718.5933db80@anubis.defcon1
обсуждение исходный текст
Ответ на Locking out a user after several failed login attempts  (Mike Thomsen <mikerthomsen@gmail.com>)
Ответы Re: Locking out a user after several failed login attempts  (Mike Thomsen <mikerthomsen@gmail.com>)
Список pgsql-novice
On Wed, 29 Jun 2011 09:54:28 -0400, Mike Thomsen <mikerthomsen@gmail.com>
wrote:



> Is it possible to lock a database user in 8.4 after several failed
> login attempts? I looked through the docs, but couldn't find anything
> about this.

I would say log attempts count in a table, reset count to 0 on good login =< 3
(trigger) and another trigger that revokes the connect privilege from the
baaad user if count reaches 3.

--
I can't drive 55.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Odd Hogstad
Дата:
Сообщение: Order-by and indexes
Следующее
От: James David Smith
Дата:
Сообщение: Re: Order-by and indexes