Postgres Pro
Downloads
Home   >   mailing lists

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

From Rui DeSousa
Subject Re: Deactivate/disable User id in Postgres
Date
Msg-id C7E7153B-3CE6-4B58-8C75-5B2FEAAC014B@crazybean.net
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


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 

Using external authentication is an option too. i.e. using LDAP; disabling the account in LDAP means the user cannot login.

pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: Deactivate/disable User id in Postgres
Next
From: Brian Hansen
Date:
Subject: Error Message