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

Re: Locking out a user after several failed login attempts

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Locking out a user after several failed login attempts
Date: 2011-06-29 14:17:18
Message-ID: 20110629161718.5933db80@anubis.defcon1 (view raw or flat)
Thread:
Lists: pgsql-novice
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.

In response to

Responses

pgsql-novice by date

Next:From: James David SmithDate: 2011-06-29 14:23:06
Subject: Re: Order-by and indexes
Previous:From: ktm@rice.eduDate: 2011-06-29 13:58:05
Subject: Re: Locking out a user after several failed login attempts

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