Won't help if authentication doesn't use passwords.
Am 10. Mai 2020 14:26:35 MESZ schrieb Ron <ronljohnsonjr@gmail.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
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?
--
Angular momentum makes the world go 'round.
--
Diese Nachricht wurde von meinem Android-Gerät mit K-9 Mail gesendet.