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

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: deactivate user accounts not used within the last 90 days.
Date: 2020-12-03 21:27:32
Message-ID: 3f8e218a-8894-3321-559a-376000c484e7@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2020-12-04 02:19:37 Re: Moving a table/index to different tablespace
Previous Message Pepe TD Vo 2020-12-03 20:51:29 deactivate user accounts not used within the last 90 days.