From: | Mike Thomsen <mikerthomsen(at)gmail(dot)com> |
---|---|
To: | "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Locking out a user after several failed login attempts |
Date: | 2011-06-29 15:26:46 |
Message-ID: | BANLkTimKbyochFMVnFwzxX4LzRomF_9ysg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gmail(dot)com> wrote:
> On Wed, 29 Jun 2011 09:54:28 -0400, Mike Thomsen <mikerthomsen(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Yves F. Barbier | 2011-06-29 15:38:30 | Re: Order-by and indexes |
Previous Message | Odd Hogstad | 2011-06-29 15:19:00 | Re: Order-by and indexes |