I couldn't find the profile setting in Postgres as Oracle and all I do is
"ALTER ROLE '${USER}' WITH PASSWORD '${password}' VALID UNTIL '${expiration_timestamp}';
thank you.
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
On Friday, August 2, 2019, 07:26:23 AM EDT, Dhandapani Shanmugam <postgresql95@gmail.com> wrote:
Hey,
I would like to know, do we have profile concept in PostgreSQL as like in Oracle.
I have a requirement to expire user password in 90 days and in oracle, I can achieve this by creating profile with custom requirements and assign it to the users. Similarly in PostgreSQL do we have options to restrict the users on password complexity.