Skip site navigation (1) Skip section navigation (2)

Re: Locking out a user after several failed login attempts

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 (view raw or flat)
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
>

In response to

Responses

pgsql-novice by date

Next:From: Jean-Yves F. BarbierDate: 2011-06-29 15:38:30
Subject: Re: Order-by and indexes
Previous:From: Odd HogstadDate: 2011-06-29 15:19:00
Subject: Re: Order-by and indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group