Postgres Pro
Downloads
Home   >   mailing lists

Re: Deactivate/disable User id in Postgres - Mailing list pgsql-admin

From John Scalia
Subject Re: Deactivate/disable User id in Postgres
Date
Msg-id 1590FC39-7BA9-4B29-953E-7C01E70E52E9@gmail.com
Whole thread Raw
In response to Deactivate/disable User id in Postgres  (Rajin Raj <rajin.raj@opsveda.com>)
Responses Re: Deactivate/disable User id in Postgres  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Tree view
Setting the role for NOLOGIN is probably your best route. You could also revoke their privileges on any database object, if you were especially concerned.
—
Jay

Sent from my iPad

On May 4, 2020, at 7:30 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 

pgsql-admin by date:

Previous
From: Rajin Raj
Date:
Subject: Deactivate/disable User id in Postgres
Next
From: Rui DeSousa
Date:
Subject: Re: Deactivate/disable User id in Postgres