Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1htWKa-0000Zw-Em for pgsql-admin@arkaria.postgresql.org; Fri, 02 Aug 2019 12:06:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1htWKZ-0008OF-9o for pgsql-admin@arkaria.postgresql.org; Fri, 02 Aug 2019 12:06:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1htWKY-0008G2-Mp for pgsql-admin@lists.postgresql.org; Fri, 02 Aug 2019 12:06:42 +0000 Received: from sonic302-2.consmr.mail.bf2.yahoo.com ([74.6.135.41]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1htWKT-0003Jq-Sj for pgsql-admin@postgresql.org; Fri, 02 Aug 2019 12:06:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1564747596; bh=x5Ybp9DT9+JK9vFrFAkRL1rlfCcdRnWjAfTrfC9uMYA=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=q2cM4gandqSrIrzx7CYaLPhdr7mfpKD64GiXck54qN2LbvnF+v6NSBR3PipQ0PL/L5SLe3gZR9HEO9i3bwJPmuCsCaWb9sLAD/l11TEoIZDcuImdCmZD/pqAtYWcG9TAyrU7ayNb4Px0OX30LzD3G9uNHdXsyxm8yI76x4Xw/acx1R6dmRRriHcNT4iJckcc93MhBBn15pZA5yVRlFWcmqpHem1KsgeS2zW2WJh5KCjzcTNdutenMYHNBmlkzBAuDQg+4BBiOq0bFHobJVQQOl0K6FZN9szvIuB05VmeO8AYeN0rWpnroj4hmcDLdNIwY56zbnLoEV9bGSrD5HwCww== X-YMail-OSG: 4krkAikVM1kSnaa2toO_fddsut7krs.yuuPGaXgo0wOiuxSbSxx9yWEMvmHdN7a 7_GHJaPo1vSS.DjJsy4fzQ9Pt7yt5LxEkEJ9iPyr2Ax2Dm5s2XZO3d_CywcUnSr8.5CCs2erfjyr tX4_aiB3RuLxFGEfw5xsCKueZLAwOcLD6HzAhSwIFJe9ZmhXOflLTmavLq2pqVJFvt5Pq.x5G2xo R7A0T1ZLM8peOSUWeV8B3pgzh7Ey7t2Ht2yIJ9MeNUUq.CiFhsj58eUNjtNdpylWw0y0HI7kEg9C jWT6kfocrl55P_qCK0LtqvoVev.AsAE5WHmwDl9uX9RaMv4OH8pHvxTf6ydEdpkNBTMYLkgAIcCQ uIjySKjDslWQd_Yn8dkUsUPfHyFEZpPb1g2Zo9io41v_F9w_KG_O0VX5IVYO7J.p9dJPwg1JihSZ diGhwgF9KleJkALteKrQDqr8znbCvvMSB86c9tiRgLpo.1nvexZCJJkGU3xw5VxK3cxVhZItbJvT 5fZDAjXY2h_sMs1GNgnAKBQR5jLSQ0VP1ADktLJR0FZjxZ.KprUdsi.PG_1oF3eLStqkO8wXow0p WsiNS9oXBUlFk5o7HODr5wV88lQMtNyi78mjmGe0aspQStDFuiPNrl9CA7NmVp2Re91Lel8UuTuw 0gbhY4GVMlbwXe5T.kphXSlzE36TBBlVyYCWz4nPNnENDoyS9RxB2UqEeg7gAMBnj_98zp5WZI1T ca46iZXXRYW536fOLTRCNq1hyNJOd8yDlVl_XZAM78TbUncuXP4yJf.3pNFYiNBHud_89GZ1xpwD ubdA87NREKhb126F6S5_AhPbPbYIzoHZglK.VJ2NqZjIon4VyxEhwyBtEd9T2c4ehT5STsxFSDO6 E2Cbpaq4nBxKObeBjc1FRqclUBfgqlweO.EBO.jZ13F0gQzB1YyYuTZvQFyQB.JW4kA7.JDA9A0o WLc03CgBjIqyPmgheefOSfkymxT0mdZ77fyPIQHdrmP8Y1G3eEElUsjgMA5rxAAF9X7sECLX_XnE UNv0RDaJ.Sv_wRI91_voIlBpyPjUGaAV8gzpwyE4V2da7ar5JuufHm1ma_YIgT_rq6AZ6VbrShQc 6wlTqOpMwGI8sQ93IH4pRSgpYJE8yy2vwifiIcs_tP2Mhu54a8w0.I75iE39idcy4WPDREydYvHw 0DCRpFh_.W6wRqJSG9wGqLsIQ8X98Z9mu0rqTcatO_r4uR0_9gyN0nCO80E3w7KkXslBP29Bhn.2 iu8gNkd7ZJLxpWNSoxWYq0Fi5.HSu5Rif Received: from sonic.gate.mail.ne1.yahoo.com by sonic302.consmr.mail.bf2.yahoo.com with HTTP; Fri, 2 Aug 2019 12:06:36 +0000 Date: Fri, 2 Aug 2019 12:06:32 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: pgsql-admin , Dhandapani Shanmugam Message-ID: <1498461632.407898.1564747593002@mail.yahoo.com> In-Reply-To: References: Subject: Re: Profile setup in PostgreSQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_407897_331795352.1564747593000" X-Mailer: WebService/1.1.14097 YMailNorrin Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.87 Safari/537.36 Content-Length: 5386 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_407897_331795352.1564747593000 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I want to know too. I couldn't find the profile setting in Postgres as Oracle and all I do is= =C2=A0"ALTER ROLE '${USER}' WITH PASSWORD '${password}' VALID UNTIL '${expi= ration_timestamp}'; thank you. Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir 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 t= o those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success=20 On Friday, August 2, 2019, 07:26:23 AM EDT, Dhandapani Shanmugam wrote: =20 =20 Hey, I would like to know, do we have profile concept in PostgreSQL as like in O= racle.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 assig= n it to the users.=C2=A0 Similarly in PostgreSQL do we have options to rest= rict the users on password complexity.=C2=A0 -D =20 ------=_Part_407897_331795352.1564747593000 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I want to know too.

I= couldn't find the profile setting in Postgres as Oracle and all I do is&nb= sp;
"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 hi= m justice though in as much as he had four legs, a tail, and barked, I admi= t he was, to all outward appearances. But to those who knew him well, he wa= s a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deepl= y **Speak kindly.
*** Genuinely rich *** Fa= ithful talent *** Sharing success


=20
=20
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 custo= m requirements and assign it to the users.  Similarly in PostgreSQL do= we have options to restrict the users on password complexity. 
<= div>
-D
------=_Part_407897_331795352.1564747593000--