Re: deactivate user accounts not used within the last 90 days.

Ron <ronljohnsonjr@xxxxxxxxx> · Thu, 3 Dec 2020 15:27:32 -0600



    On 12/3/20 2:51 PM, Pepe TD Vo wrote:

    
        Hi
        

                  May I know how to deactivate the
                    user account not used within the last days in
                    Postgres?  Is there a function for password lifetime
                    liked Oracle?
                
              
    https://www.postgresql.org/docs/12/sql-alterrole.html

    
    Look at the VALID UNTIL clause.

    
    -- 

      Angular momentum makes the world go 'round.