Re: Deactivate/disable User id in Postgres

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