Re: Deactivate/disable User id in Postgres

Won't help if authentication doesn't use passwords.

Am 10. Mai 2020 14:26:35 MESZ schrieb Ron <ronljohnsonjr(at)gmail(dot)com>:
>What about setting the password expiration to "now"?  That also would
>prevent the user from logging in.
>
>On 5/4/20 6:50 AM, John Scalia wrote:
>> 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(dot)raj(at)opsveda(dot)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 *
>
>--
>Angular momentum makes the world go 'round.

--
Diese Nachricht wurde von meinem Android-Gerät mit K-9 Mail gesendet.