Re: Deactivate/disable User id in Postgres

Holger Jakobs <holger@xxxxxxxxxx> · Sun, 10 May 2020 15:20:49 +0200

  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.