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 1p6Alf-0005lU-8k for pgsql-admin@arkaria.postgresql.org; Fri, 16 Dec 2022 13:28:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p6Ald-00071D-Hr for pgsql-admin@arkaria.postgresql.org; Fri, 16 Dec 2022 13:28:49 +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 1p6Ald-000713-0w for pgsql-admin@lists.postgresql.org; Fri, 16 Dec 2022 13:28:49 +0000 Received: from sonic315-20.consmr.mail.ne1.yahoo.com ([66.163.190.146]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p6AlZ-0001QV-Kw for pgsql-admin@lists.postgresql.org; Fri, 16 Dec 2022 13:28:48 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1671197322; bh=+Qx06PL1c6I7Wb9wvx/QbLXh8RMtqmmjfaAdJAtFOxI=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=EVvrLVQzqwB7wUoVvqGTusJW/OBHTnBgkzqOHdEZR8dPooei77pIHK4UtQ4KxHjjdjn1kW0ltS/uPSbu0b+uFMdY+5hO0ks/YSPHtpiGn8b/hZbUQzNhzKnQ+IdqFkU7+JnDnhjrYzb88C7klMjS0H8id9KgRHGCaX5rQS4p0tk3+KVmaXUlZ5/FM+cv8+hubMcqyTEd4g63YbxQtyWirCpM5UsZt2SYTFPAVKS2jXajss7TgZJsTzKlQ+kgwOdnW9qik7YTM8ZgOgea0A5Z7c3sJvmZ1+AcLTzNbetHkYzQFmAGft5MirFgzkETRJOFXX+M9cyK0ePpHEA8dSuT8A== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1671197322; bh=9ebqLI1fh7aRLmAP+8ov2xcvmG/sEOWMstbw5WrmuM5=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=VcnuBjUuv1bCCgBsGzv+0qEguws0ug33wn5pVWh34j4zeOJcfvljYk8dbhERhtk7jXVrucPBIIaG+EdXHmx+iClOxtIGCaZhm3HdPT2LKFgTExPhu1SshpVx8LIcdc3HNRBJ1L4wMTa3U+XD1Suwjk8ViMKqHHjxBy7dJ45x0W78TnMzKxxgQ6maEMvccubNd3tcLiDCfiWbD2XefIOOqYKk6GuERjw5++YhirlUTOoECQS4+5BvPzECEeTRKR7btxYGR4XdM6Exgj1W+vTfo7hHwOy7jG8LMAVqimM1XKJhEP4IbFULnuZVCxe15wDXqGMJEQQm4i3O27t8N2vJfQ== X-YMail-OSG: 5XYzNlsVM1kBBr5.1IEGj6okTG0njKVinOPbuaOFkUK_zoua5gnDTDRpBb.pu75 2bygx7qwV0PxkuosqUyWph_kvieaRz16B6SujmEZHhBd435_Rb9mNVqDQ0_jXq.5zWKp9Cdp7TsQ mWLCe9YJyKoayzTP3bvu5AhgGlGVBmaCj6L8Dn2aVIxM9Q9Zs48e7Nkiq3qesCIigj4CV7BYe9Ti nojEk3Pw4kjl0m2iby.pNVtHd.A6RBP_mgBgb_XyxQt7ubSOeun8a086m47D4JcFcxScEgozFYbB XobvaEf_kIaO7h7wcH1IKLNs3OJ0ybM5xZLRO6c59DxcQvq0Vd9BL0_t2r7FGZ9.C71AL9wVpV7A LbdbNdxJjvoJeEXZmMPVDJCd_8c7YJ8CBqLE09MYOpHZaLuolpGMK2AmLiSBlgS87LwcLxWPKxP1 T2.IM.2PdMnG4TQl_oMUBPJLt7Qu1qhmMH8T.Ivl2PNcmZXK2jgSSVuaBXiLaWHv8bsepxyOwivh 3kY32vSfhJrqOrOThbgIoFgwQbyqF_ANeNCK_KuFG8TxD1sRY7RN6feRu1v7spqa72xUFO7UoZy3 PJyU3NZ7xUgzZy7r0y5r0BH8bBA1ltPcfvcFGm0q92C37cely.cThe_ol9SKVL6kR.wg4_aRDTDw R.yK5iqiAiILC6Y71kfx.BxKeKAzjgSkUEX3lp8yan5RVcf0RUNqYPUptgETRcf.hHS.MZnpXrDI Qc9ejVGanBSscbb2VSwNeolbfwUezfESooQv84.GBR8nhkb8jUW.v5h7AJQ4WMaJBuSAx3zNbw1q 6A6mBd5Q4qfzEb4fSpIcXW3cK4JIK3ozAyACdp9pehv0hqhkGaDa0GVHhNt.ggWlGIBl3DFFWtmq 271Y0wT5i4gU4Aev3Fw1cJJhUoyZCcKHkmmCDEdJqh6K4jtHdZTZSsPEgoULKdA5vRmVn3YFXmUQ Zf_PA0q1uORyY1rSdzXQILMEp9dE3UFwjN.nfdixB_iZO1hZJDNZoe_jqJOm2.0j1S.7K0cmNPkb XQCJT5YdzT1IAhF3lVM7mXpSxgKDar.5s6WjRatbWvwh2A8rgzVHKNiZga4KQ8JTMXFbOcssYDg8 4tzx1kF3k1Xol6qxork0acEWCW3txtb20NDheRyUTCML8MoRljJhGniKSJpZI4A_jZrK0WI7mrOo 8IQ30uot85_nCyeow9Vk8qJQC19S2mqp9DnhR7iyOtKLe8Y.YcQbI_sIb1YF51t5DB0W5OFlGkot CyeNgnkj5NJKAD7_Kh0qnsSDK.BN4FwAtWzr2UywKNnGxCHEyTHlQSRxXABwXKPOcxauE9WbdjqJ zUI0qnr5tCfXBb6ghGd_6dEPsuf589.QaTzCEdrvKyRlbk2m2dBST5WVGCbpdIEkoz8BSwCFrbYD EAl1eCDTpNmEC72BN9hNWFjRmT0t8ot2VZI4TZF_rVrnb_Tt5S6G4aK8FX6zq4HGbJJIZuJ9FUC0 bPi85V8G6.cRuAYgQPlplW9AuCL1faKzXLEAPYWYd6dc_tC5AJvN0BDU1GsWhnTpohxkqL4lWFqB w66FlmVChuyQABx4GoZ6gJXrWs4XD83OxoxOyzhDG6U9vP8gwk.AOPXTT0p92iIYHeY3VBrEENE. NP7ILKgvhJUVCFfOmsDXhfMK82tUAYeIY.KIKLWzRUwh2k88W615MsOj55t7XyQ8AvygKMaIofvi Y5ZAVv4hFW3tQsrOQsZU017kUKkBQtz2aRdl4l_uuGg84STlAqJYB8HpZSFJqIw4HuTzZpHnwzUW eh8rYtiWmrdbKj2a.Wo4AueeYmvhJCLLLK64v4FcHGUxeSE3jkaFTy6gx9O_HgD2nEuJ6JOtBPKV Us_j24oBczNi8zoh.IyZ7GTO4QCFn2L4EfWpnQI0mRTsQ84SuW58UJC6qUmTsIa1tW_vGn2rv1w1 FDBAOkJh2l1CehPo_F6pKHAAtPsvKPktgGvq2g2Vw5y6.Z6R5TDBgYz76OGD9LswnCmWBBMTxeZ4 oKvv_KO6WWTbgdA1XYBFO0QMvquRGkK.AYIk2On9DRqNiZOgM_OR0I40vHJ4sAyLB4NqdKBwZiBM 0lUV3hc_XtjN2zRFGO5.H_TN3p8i60EyGmCoGJaPig088YrNT_y1ZiiTN8pS9wiap51r73X1Q7oC UbeCDxHXgwBM08fZwPKMMsbDZJ9w2LraJlha6fa8m3qmvWASJ4h8sykODax6Ii_aGpKaFzZ9hyGb 0N6ohdkeVm8AxdBE6xnCr_ThpkN55H.HUArsFaLyg49uTpse7R_T5gp6Uz1uGJCjaKOjatO8kEgR CWuoLOliX4gzIPq_2rn6egDs2jhwuxBjSJCXq4w-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic315.consmr.mail.ne1.yahoo.com with HTTP; Fri, 16 Dec 2022 13:28:42 +0000 Date: Fri, 16 Dec 2022 13:28:41 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: pgsql-admin , Daulat Message-ID: <985925604.844911.1671197321366@mail.yahoo.com> In-Reply-To: References: Subject: Re: Password complexities in Postgres v14.6 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_844910_1986958865.1671197321364" X-Mailer: WebService/1.1.20982 YMailNorrin Content-Length: 9194 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_844910_1986958865.1671197321364 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable you can configure the password policy plugin in postgresql.conf. p_policy.min_password_len =3D 8=C2=A0 =C2=A0 =C2=A0 =C2=A0# Set minimum Pas= sword lengthp_policy.min_special_chars =3D 2=C2=A0 =C2=A0 =C2=A0 # Set mini= mum number of special charactersp_policy.min_numbers =3D 2=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 # Set minimum number of numeric charactersp_policy= .min_uppercase_letter =3D 2=C2=A0 =C2=A0# Set minimum number of upper case = lettersp_policy.min_lowercase_letter =3D 2=C2=A0 =C2=A0# Set minimum number= of lower case letters 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 cal= l 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) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success =20 On Friday, December 16, 2022 at 07:28:05 AM EST, Daulat wrote: =20 =20 =20 Hello Team, Any idea, how we can set some Password complexities inpostgres for user pas= sword. Like, we can create profiles in Oracle.=20 I am looking to set the Password complexities=C2=A0 (one parameter from eac= h line item has to be complied to): Default password age for users: 90 days.=20 Password first letter will be alphabetic in uppercase. English uppercase characters (A through Z) English lowercase characters (a through z) Base 10 digits (0 through 9) Non-alphabetic characters ~" &_-+=3D'!(){}[):;"'<>,.?/ !@#$%* Password Minimum Length 8 character Thanks, =20 ------=_Part_844910_1986958865.1671197321364 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
you can configure the password policy plugin in postgresql.conf.

p_policy= .min_password_len =3D 8       # Set minimum Password le= ngth
p_policy.min_special_chars =3D 2      # Set m= inimum number of special characters
p_policy.min_numbers =3D 2&nb= sp;           # Set minimum number of numeric char= acters
p_policy.min_uppercase_letter =3D 2   # Set mini= mum number of upper case letters
p_policy.min_lowercase_letter = =3D 2   # Set minimum number of lower case letters

<= font color=3D"#0000ff">
Bach-Nga

No one in this world is pure and perfect.  If you avo= id people for their mistakes you will be alone. So judge less, love, and fo= rgive more.3D"Emoji"=3D"Emoji"3D"Emoji"
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 gentl= eman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.=
*** Genuinely rich *** Faithful talent ***= Sharing success




=20
=20
On Friday, December 16, 2022 at 07:28:05 AM EST, Daulat= <daulat.dba@gmail.com> wrote:


Hello Team,

Any idea, how we can= set some Password complexities in postgres for user password. Like, we can create profiles in Oracle.

I am looking to set = the Password complexities  (one parameter from each line item has to b= e complied to):

Default password age= for users: 90 days.

Password first lette= r will be alphabetic in uppercase.

English uppercase ch= aracters (A through Z)

English lowercase ch= aracters (a through z)

Base 10 digits (0 th= rough 9)

Non-alphabetic chara= cters ~" &_-+=3D'! (){}[):;"'<>,.?/ !@#$%*

Password Minimum Len= gth 8 character

T= hanks,

------=_Part_844910_1986958865.1671197321364--