> On May 4, 2020, at 7:29 AM, Rajin Raj <rajin(dot)raj(at)opsveda(dot)com> wrote:
>
> Hi,
>
> Is there any option to deactivate/disable a user id in Postgres?
> I can think of below two options,
>
> ALTER USER <user_id> WITH CONNECTION LIMIT 0;
> ALTER USER <user_id> WITH NOLOGIN
>
> Is there any better approach?
>
> Regards,
> Rajin
Using external authentication is an option too. i.e. using LDAP; disabling the account in LDAP means the user cannot login.