Deactivate/disable User id in Postgres

From: Rajin Raj <rajin(dot)raj(at)opsveda(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Deactivate/disable User id in Postgres
Date: 2020-05-04 11:29:43
Message-ID: CAOasRJb7gKDZMjfVAmh2Bg4hGfm_=qoE8LvJimhY7mATbN=pmA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 *

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2020-05-04 11:50:30 Re: Deactivate/disable User id in Postgres
Previous Message Guillaume Lelarge 2020-05-04 09:30:39 Re: psql copy filename path wildcard