Re: query to show locked / disabled users?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Sbob <sbob(at)quadratum-braccas(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: query to show locked / disabled users?
Date: 2022-04-14 19:24:17
Message-ID: CAKFQuwYZAtVfSokLgqCevemAeVAVayFdssdOTDnb8SSerM7mVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thursday, April 14, 2022, Sbob <sbob(at)quadratum-braccas(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2022-04-14 19:34:42 Re: query to show locked / disabled users?
Previous Message Sbob 2022-04-14 19:19:38 query to show locked / disabled users?