Re: Deactivate/disable User id in Postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

Am 10. Mai 2020 14:26:35 MESZ schrieb Ron <ronljohnsonjr@xxxxxxxxx>:
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.raj@xxxxxxxxxxx> 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.

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux