Postgres Pro
Downloads
Home   >   mailing lists

Re: query to show locked / disabled users? - Mailing list pgsql-admin

From David G. Johnston
Subject Re: query to show locked / disabled users?
Date
Msg-id CAKFQuwYZAtVfSokLgqCevemAeVAVayFdssdOTDnb8SSerM7mVQ@mail.gmail.com
Whole thread Raw
In response to query to show locked / disabled users?  (Sbob <sbob@quadratum-braccas.com>)
Responses Re: query to show locked / disabled users?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
On Thursday, April 14, 2022, Sbob <sbob@quadratum-braccas.com> wrote:
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?


 You can look at pg_roles.

David J.

pgsql-admin by date:

Previous
From: Sbob
Date:
Subject: query to show locked / disabled users?
Next
From: Tom Lane
Date:
Subject: Re: query to show locked / disabled users?