Re: Locking out a user after several failed login attempts - Mailing list pgsql-novice

From Mike Thomsen
Subject Re: Locking out a user after several failed login attempts
Date
Msg-id BANLkTimKbyochFMVnFwzxX4LzRomF_9ysg@mail.gmail.com
Whole thread Raw
In response to Re: Locking out a user after several failed login attempts  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
Responses Re: Locking out a user after several failed login attempts  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
List pgsql-novice
From the sounds of it, it's not a standard feature. Is that correct?

On Wed, Jun 29, 2011 at 10:17 AM, Jean-Yves F. Barbier <12ukwn@gmail.com> wrote:
> 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.
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

pgsql-novice by date:

Previous
From: Odd Hogstad
Date:
Subject: Re: Order-by and indexes
Next
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: Order-by and indexes