Re: Deactivate/disable User id in Postgres

On 5/4/20 9:45 AM, Rui DeSousa wrote:
>
>
>> On May 4, 2020, at 7:29 AM, Rajin Raj <rajin(dot)raj(at)opsveda(dot)com
>> <mailto: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 *
>
> Using external authentication is an option too. i.e. using LDAP; disabling
> the account in LDAP means the user cannot login.

That would be a disaster in an enterprise that has many systems, and uses
LDAP/AD for account management.

--
Angular momentum makes the world go 'round.