Postgres Pro
Downloads
Home   >   mailing lists

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

From Rajin Raj
Subject Deactivate/disable User id in Postgres
Date
Msg-id CAOasRJb7gKDZMjfVAmh2Bg4hGfm_=qoE8LvJimhY7mATbN=pmA@mail.gmail.com
Whole thread Raw
Responses Re: Deactivate/disable User id in Postgres  (John Scalia <jayknowsunix@gmail.com>)
Re: Deactivate/disable User id in Postgres  (Rui DeSousa <rui@crazybean.net>)
List pgsql-admin
Tree view
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: Guillaume Lelarge
Date:
Subject: Re: psql copy filename path wildcard
Next
From: John Scalia
Date:
Subject: Re: Deactivate/disable User id in Postgres