Re: Deactivate/disable User id in Postgres

Ron <ronljohnsonjr@xxxxxxxxx> · Sun, 10 May 2020 07:26:35 -0500



    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.