Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkw8d-0004oZ-1o for pgsql-admin@arkaria.postgresql.org; Thu, 03 Dec 2020 21:27:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kkw8Z-00030J-Si for pgsql-admin@arkaria.postgresql.org; Thu, 03 Dec 2020 21:27:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkw8Z-00030C-Ir for pgsql-admin@lists.postgresql.org; Thu, 03 Dec 2020 21:27:39 +0000 Received: from mail-oi1-x22b.google.com ([2607:f8b0:4864:20::22b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kkw8W-0002Ug-Qe for pgsql-admin@lists.postgresql.org; Thu, 03 Dec 2020 21:27:39 +0000 Received: by mail-oi1-x22b.google.com with SMTP id p126so3801244oif.7 for ; Thu, 03 Dec 2020 13:27:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=v+qvszzYhFg9+Wq9uVw1+qtbXKdXdCzjivluYZYB59Y=; b=PTQSqStjgslGV7hpGuqGaKrEXeg81XWOZdj4HFLUusj2g2HC/vYmA2Vnj5eM2ymvBr NKsAy7Z0GnLnH6wui7eyEzWfYd6ALogKSWjlgFhZA0LxQtX7DsyuUJQ2XiICDD2osA+f 6erBGqZ52ggWYzi782J8Yy4oxBfz+8SSABECOG5HMkGfyZJ7obNkHqF6AjU5Qsb/mCNH 6gWKadeVsgTnoL3OuMlTCHYHvV6SJTeQBiDMHiXU9ltA6duZmbnb1wunWHMeEPKNLoUD 04iv5wSad+H5X5GRi8yIF9n90eCPz4bCxX5uytLuWik5P3MxJFJlXrzLARNwI66/21ar EPHw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=v+qvszzYhFg9+Wq9uVw1+qtbXKdXdCzjivluYZYB59Y=; b=YdwcMxTRwSsT7EYB1mVm9Wej8CSZtdqTHd5lq6VUTGe3f6ZyU58BMFVmZMpQ09IcfQ gMIPeZmc2iCARBMly1sLIxSczFUk6eamDJJ1QvLAalUuYa6Nw3y4LJaji9CsPHLWutLM jHivvn52eswrqkLlr4S87O/8ixpH9cK0Y8Tl1uzKe5JGpHQTmr9OYlRbR5enjCEw+RQd rCAql7HlZNsQ/imehiipONow65rBcMgoLH6cHREGsQqpSqGa7QJbdTcqqg+iR40aAQcO sOXwSDEZjR9d147lbrjjG6kDWfvsc/rkDDNgELBaKfLZqXyiJdSt6Yfd0koWSOTNwAM3 SrPg== X-Gm-Message-State: AOAM531qHj+MXLJKD6TZQ0Ktw+0x4NWNxEmhmiiGW073AuuJgFQagpW3 QJoN+mRnRvgdbD2Prka5gEL86ZkUWgw+0Q== X-Google-Smtp-Source: ABdhPJyl2zNPrQr7bC1Ha+FTFtr8VvrhM1GLirS+c2MtnlrkmFt271THY0k3XsOc7ialQhyJJIHr0g== X-Received: by 2002:aca:498e:: with SMTP id w136mr775913oia.147.1607030854356; Thu, 03 Dec 2020 13:27:34 -0800 (PST) Received: from [192.168.1.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id z10sm189613oom.3.2020.12.03.13.27.33 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 03 Dec 2020 13:27:33 -0800 (PST) Subject: Re: deactivate user accounts not used within the last 90 days. To: pgsql-admin@lists.postgresql.org References: <1562396089.2669945.1607028689050.ref@mail.yahoo.com> <1562396089.2669945.1607028689050@mail.yahoo.com> From: Ron Message-ID: <3f8e218a-8894-3321-559a-376000c484e7@gmail.com> Date: Thu, 3 Dec 2020 15:27:32 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: <1562396089.2669945.1607028689050@mail.yahoo.com> Content-Type: multipart/alternative; boundary="------------14F09888E76C9D49E189C79A" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------14F09888E76C9D49E189C79A Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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. --------------14F09888E76C9D49E189C79A Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit 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.
--------------14F09888E76C9D49E189C79A--