Re: Deactivate/disable User id in Postgres

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



    On 5/4/20 9:45 AM, Rui DeSousa wrote:

    
          On May 4, 2020, at 7:29 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 
                            
                          
      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.