Re: Deactivate/disable User id in Postgres

[Rui DeSousa <rui@xxxxxxxxxxxxx>]

On May 4, 2020, at 7:29 AM, Rajin Raj <rajin.raj@xxxxxxxxxxx> 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.