Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nf50O-0005A5-GL for pgsql-admin@arkaria.postgresql.org; Thu, 14 Apr 2022 19:19:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nf50M-0005CV-Im for pgsql-admin@arkaria.postgresql.org; Thu, 14 Apr 2022 19:19:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nf50K-0005CL-O1 for pgsql-admin@lists.postgresql.org; Thu, 14 Apr 2022 19:19:46 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nf50H-0005lq-Bc for pgsql-admin@lists.postgresql.org; Thu, 14 Apr 2022 19:19:43 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 064515C028B; Thu, 14 Apr 2022 15:19:40 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Thu, 14 Apr 2022 15:19:40 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= quadratum-braccas.com; h=cc:content-transfer-encoding :content-type:date:date:from:from:in-reply-to:message-id :mime-version:reply-to:sender:subject:subject:to:to; s=fm2; t= 1649963979; x=1650050379; bh=cS/yiNl5tmQroWyMYPW9S0XUmgRTTh5zJki mKdFMN2g=; b=WWGamo9Ma/XkcZRUVdCrhwjOJZFFshf5bdDDqoWVbkUbI8788RM z0nd3o21qg2Wf91Rv5iE90kdthyjRLlYXkZL1ojZi1g95S7RgH7E/juoQkGfa+H9 1MdPgWFjfOrQBLmgEAxdj4n8Voo9QePw07Zlx2PbZyJ/zqY60LWUlCpr/MAoETpL Lbj2T21aOLr7r+BlTpyxbUIAW5DABV/Z1mdDW1TUp6o+Rx1m+yq8fVdbJtMJe5Rq bemw9reNujNvWT7Ri21wh9H/0MfjIdChh1u/2U1z5is96Gw5yPoPcGlYEDr6aXyO a0tNBQkWcfdiL/AKAUzj4ZsOUl5VK5JhRzg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:date:from:from:in-reply-to:message-id:mime-version :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1649963979; x= 1650050379; bh=cS/yiNl5tmQroWyMYPW9S0XUmgRTTh5zJkimKdFMN2g=; b=O 0a6ZDuEN3AqdDDVz67az1j/noNuJPzkPAJoMxsYiHsEDC3YA1yNtqtHIWoZiNPg6 4pl+B6TC3v8RN3eQGDaHrDsvi86hqxo8jwPd+Z5gx5ZuowMhQUlJETL1kSpg1z0k S3GAfgz2n1nRlb29OQ9tFNSaFpv40lVYC57wl6Az8G2WUPVdzSGrP8RfuN7Lv4rz Ewp8ZKc5eTDzKb/tq0r7UL6NJ2ZaKepLye3rN97A3AK/gzN6JxyvToqFVAAGbqQL 8JXW20wc65FxH9KU+dZRFm6mfrUKdIeOi78wtTJK+Z7Rxt9xM/hTFCvk0FiKuZyW NLRo0xGMLNq5/wiPZ17Fg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudelfedgudefkecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecunecujfgurhepkfffgggfvffhufgtgfesthekre dttdefjeenucfhrhhomhepufgsohgsuceoshgsohgssehquhgrughrrghtuhhmqdgsrhgr tggtrghsrdgtohhmqeenucggtffrrghtthgvrhhnpeeukeeulefgvdejveeghfduvdegge evjeefteegfedvjeeigfejjedvveduveejieenucevlhhushhtvghrufhiiigvpedtnecu rfgrrhgrmhepmhgrihhlfhhrohhmpehssghosgesqhhurggurhgrthhumhdqsghrrggttg grshdrtghomh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 14 Apr 2022 15:19:38 -0400 (EDT) Message-ID: Date: Thu, 14 Apr 2022 13:19:38 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.7.0 To: Pgsql-admin Content-Language: en-US From: Sbob Subject: query to show locked / disabled users? Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I have a client that says there were break in attempts and many db users are now disabled / locked because of too many wrong pw attempts. Is there  a select that will show these users? Thanks in advance