Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fxg8N-0005Sn-Bi for pgsql-admin@arkaria.postgresql.org; Wed, 05 Sep 2018 22:18:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fxg8L-0002Ap-7G for pgsql-admin@arkaria.postgresql.org; Wed, 05 Sep 2018 22:18:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fxg8K-0002Ai-Ty for pgsql-admin@lists.postgresql.org; Wed, 05 Sep 2018 22:18:45 +0000 Received: from mail-oi0-x243.google.com ([2607:f8b0:4003:c06::243]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fxg8I-0000hf-AH for pgsql-admin@lists.postgresql.org; Wed, 05 Sep 2018 22:18:44 +0000 Received: by mail-oi0-x243.google.com with SMTP id x197-v6so16755908oix.5 for ; Wed, 05 Sep 2018 15:18:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=lJQ2h0NAQ8shXmSq+VWHrVosi0X65uA7YE1mCqKXEAo=; b=slekiwRzi+PrQATIeyNGiVvnj0qHbywumFKNKcgOYXqqKN/VnsTEcB2cJMZcZEsiMX K/UvpzSiIozRqrYaizoJmw6a5zQZ1L//SaNRu22pFuDg1qpxjp5Z4Q8nDdUMfcBBOKFO iLzGqokWRUz29GexLsRzmH73jwMb+kvGSOm6OHCzTheNfUnAOdxjcCh/XR2EnH226Xii aa3gxoHBNQ6I2v4ImLeYwcr+SNitvU7BD/syo6ydCEA5Fhu7jDFCDjuMBHbNjZKHSa/M wcY/kBwy9dirlU9DWpWgA/uM1d8SUnbS0bFGd97vNZDtf4HJLP2aJc6QHFSqLnCSdQ/A +HFQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=lJQ2h0NAQ8shXmSq+VWHrVosi0X65uA7YE1mCqKXEAo=; b=sJh4xNw6IYQ5SIcTFidUDmZSz9jxJlT8ACHAJyIpKcsUfsv91E8dL/HlqsSZ3nVxE2 jKEZL6tYd/E+QHxlM4dJEe7DWv3fmZddYn7QOkQ00uOreqDRECh2ePs07z0ge04pL+lE 8VQ43P9jtsOr4WQt6xeYEPLyPkpDQNusOXAD2m58xCRtZzxLWnA7D1tD4WQFxree4DRM yPWrFmfJM6N84tVoliFbxVRgFUJykviVHwyv5+2cH0bOEArUq08x5oqS7b83wtEMLVJ5 dmV5180YrBZ+Gyxe4jcOwnyJgbrc8bcB3xuuQXWE7jmUhexApcQlSS5fWaBPI0XFVfWm 89wA== X-Gm-Message-State: APzg51CgFW63KW+OY0bQyTJIJeGrvY6DQHs7BcElvU+Jwe7aupBq4sCC iE90x9dAAdme48/9YABch1r4TIez X-Google-Smtp-Source: ANB0VdaSwK6G8ELVazHZs1Y22G7HQh3QHQ++hWN91HvWelo+Rwr1fYN8Ij0wzu0f4sVH7lfps71coQ== X-Received: by 2002:aca:4b0d:: with SMTP id y13-v6mr33961192oia.198.1536185919938; Wed, 05 Sep 2018 15:18:39 -0700 (PDT) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id k85-v6sm8991851oiy.2.2018.09.05.15.18.38 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 05 Sep 2018 15:18:39 -0700 (PDT) Subject: Re: User to get locked after three wrong login attempts. To: pgsql-admin@lists.postgresql.org References: <30655.1536069964@sss.pgh.pa.us> <20180905174832.GO4184@tamriel.snowman.net> <87va7j61g2.fsf@gmail.com> From: Ron Message-ID: <1ea8bec3-1d0b-b69f-cbc0-c936860696f4@gmail.com> Date: Wed, 5 Sep 2018 17:18:38 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------35F139995AFF746E41EA9453" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------35F139995AFF746E41EA9453 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit On 09/05/2018 05:14 PM, Craig James wrote: [snip] > To elaborate, you should explain to the auditor that this introduces a > huge denial-of-service vulnerability into your system. Anyone can start > hammering on everyone else's accounts, and with a fairly trivial script, > lock the entire company out of all accounts. This is a terrible idea. And be tracked down (relatively) quickly. -- Angular momentum makes the world go 'round. --------------35F139995AFF746E41EA9453 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit On 09/05/2018 05:14 PM, Craig James wrote:
[snip]
To elaborate, you should explain to the auditor that this introduces a huge denial-of-service vulnerability into your system. Anyone can start hammering on everyone else's accounts, and with a fairly trivial script, lock the entire company out of all accounts. This is a terrible idea.

And be tracked down (relatively) quickly.

--
Angular momentum makes the world go 'round.
--------------35F139995AFF746E41EA9453--