Re: deactivate user accounts not used within the last 90 days. - Mailing list pgsql-admin

From Ron
Subject Re: deactivate user accounts not used within the last 90 days.
Date
Msg-id 3f8e218a-8894-3321-559a-376000c484e7@gmail.com
Whole thread Raw
In response to deactivate user accounts not used within the last 90 days.  (Pepe TD Vo <pepevo@yahoo.com>)
List 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.

pgsql-admin by date:

Previous
From: Pepe TD Vo
Date:
Subject: deactivate user accounts not used within the last 90 days.
Next
From: Alvaro Herrera
Date:
Subject: Re: Moving a table/index to different tablespace