On Thu, Jul 22, 2021 at 9:19 AM Ashesh Vashi <ashesh.va...@enterprisedb.com>
wrote:

> On Thu, Jul 22, 2021 at 12:27 PM Akshay Joshi <
> akshay.jo...@enterprisedb.com> wrote:
>
>> Hi Florian
>>
>> Thanks, the patch applied.
>>
>> I have changed the flash string from 'Account locked' to 'Your account is
>> locked. Please contact the Administrator.'
>>
> I have a scenario.
> I have only one user in pgAdmin.
>
> What would happen then?
> + Does it lock that user too?
>

Yes.


> + If yes - do we have information in the document to unlock that user?
>

I hope so :-p


>
> I am also curious about another case. A hacker can use multiple users for
> the same.
> Should we also lock/avoid requests from a particular ip-address/machine
> for X minutes/hours?
>

That's more difficult to deal with - there are common deployment scenarios
where all connections might appear to come from a single IP, for example,
when behind a load balancer (there are good reasons to do that, even with a
single pgAdmin instance) or proxy. In such cases we may or may not get an
X-Forwarded-For header, and even if we do it may not be reliable.


-- 
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com

Reply via email to