Re: Temporarily suspend a user account? - Mailing list pgsql-general

From David G Johnston
Subject Re: Temporarily suspend a user account?
Date
Msg-id CAKFQuwZvUxav8Qi7Bomt+7=rMTtn4-=YYfoHokQ0tCxBvBFWfQ@mail.gmail.com
Whole thread Raw
In response to Re: Temporarily suspend a user account?  (Felipe Gasper <felipe@felipegasper.com>)
Responses Re: Temporarily suspend a user account?
Re: Temporarily suspend a user account?
List pgsql-general
On Fri, Feb 6, 2015 at 3:41 PM, Felipe Gasper [via PostgreSQL] <[hidden email]> wrote:

So, this works when I do it manually, but not when I script it.

Is it possible that this change doesn’t take effect immediately? Is
there any way to tell when it does (besides just waiting until login
attempts fail)?


​It should take effect when you commit the transaction in which you perform the update...

The active sessions would remain logged in but future attempts to login would fail.

​David J.


View this message in context: Re: Temporarily suspend a user account?
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Felipe Gasper
Date:
Subject: Re: Temporarily suspend a user account?
Next
From: Felipe Gasper
Date:
Subject: Re: Temporarily suspend a user account?