Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s636r-009mk0-C6 for pgsql-admin@arkaria.postgresql.org; Sun, 12 May 2024 06:55:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s636p-009VRF-Md for pgsql-admin@arkaria.postgresql.org; Sun, 12 May 2024 06:55:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s636p-009VR6-BU for pgsql-admin@lists.postgresql.org; Sun, 12 May 2024 06:54:59 +0000 Received: from sonic314-22.consmr.mail.ne1.yahoo.com ([66.163.189.148]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s636i-000bAy-E2 for pgsql-admin@postgresql.org; Sun, 12 May 2024 06:54:58 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1715496890; bh=YgUuKhs0T5/1Ej0J+JTZZLcniFYVlVRNjqxSzRRhdis=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=XUVYC5PfWFRAf02fwfslbrnyYX7zVrqGq28KrnCYQwywvzS0Wxm49wjQtsYKhUSnjqxcjUtTocEVnZN4NxI5Jidj5ZQCXlgkujkcBeaj8PbPT6VukdafZGteA8CNde9A4cgjMArpD3pBZKWjv5fMyu9iy9Mcb96OxP/Uz/N1Zfv3Cei3ReNhPpTIRDwfA+93WgxdTc9oJj93TyrBHiUymljb/ccB9qQt8FhE2fOnsqTkEg/3nAscbH/BCQM1+1whw+FWJPwUGxccWjlvH9QwhnXVpWyW35xjkewrewVwG1MVyiShMxqLQoUHvITreWg2PfmOj+fP/5P+yvHvJAAzLA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1715496890; bh=BtzVa6NFsFQfWLGoBN+07NC0xQYI8ypzmQg+FPekvj8=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=s2yaX9I60h/wJ/cSbs4mPaozshunEePzWWWuWmbAaLtCn1pSPO7qi4JWwQHzHehUOrXOekORXarWxGU0HbSQG2a2uMQjszdGfhG5VkeNYrF2DQivN0KDG+MkEnmZ0E9Uip8xkY9TKZ2xatJChEJTtejvvmRGiZ6lmZEcjplkR5J35IcEmo5iNv8AH2mSMVAicWiSpR/e8hV2FdLUbiB4VIN+17fFH+T9bRYETpGckIYkCcEBaOniL/rgx6JwQipY02PMTMcw8RbjTnVIDoe+O7S36TAqDCbh7LvhKmF5k0E0ouBqDr+TBbFsYANsbFBnuUugJhcgSGy2+1cgI/L/PQ== X-YMail-OSG: AChFJ74VM1mfOBaAwSBJRUYVTCFF0RxGwT2V7A3ptdNQyk9.4B_RIeDl7FUfs0G Xl6_kG3Vx2qqrtYzQdfJfeUSYQqS5QXIMw2DJz4SlWFuufn19V9BuqWiTaYeaT_oluxBpZmFn_wg E7ZEuIHRr.nDPWakk_v1EOCPH7GPnV.opvXnLHkJ1FfW9KKO2J.Nwh9vTAjY2F.2lOqHM4O0HPYV ARamdc7GngF5NKtv_8EosznFcEQpWaFSoDgvfXNpm9vUwQSEcCScvwbT6bkmMt5pB0.x0dOpvxaP gpfV1WJPQ3es7Glny8Od93.W8i7kIVoZrnQtGpHfIuzYV0fpmpD8yKDorrAOY.Kw4Tk.PXI.Vfkr e6UG_IjWQGTscmfI8TyWRS4I915fzhV..QPLh1wPVzjdYvxY.ae4a55XaLR3AvJZKEsIMdVIg7DU 5uNgK67unlJYrxqy8aG4SOdw878eJQk9JJvh2phcFqU9G6uUmbcgUv9AnEhr7KYId6tIBhxWgBYz Z73KUdniGAliO0SnEciO3coxEtoi7Zf3ZMJ3l8vd80VPCaakoD5LVeHrQ4Gku3C7w2N7ytIsrgw9 TbRyyayeUH6WAZYnqdN4ypZKGkzA3Fqw7m8KDr2DSDkcW0voZQVzW59E9sa2sb5dOb.yrrH5rC5B O0Nitzkcj6DrSTI4SOz2mKYX7NGOc7EWIF1hqpvAMcRH6QIpOhit.fVOSRXsUzSgyRYFmoE6f0Tf GlH03UAwIl1CSIvHtouDtabeto3xIYjPK_kjugGaItB.Q_xhspx3Q4RmXilAWjuaeVk2NIQr6icF JIqqDcXlJMqml0KvY5ilVrj1SHzzIb_JGOKwGwABTptpdnnBmxd2r57ZmOJSS95UmyEp6TwaT7A3 Pp0Ze_ToHU.F4Q8mcI__zsyqwViedLz_3epDeKo.08meTZrp9JoIU1n5LmLJm3Mbk1cD.c3OdwiX BB2EcyWHZscAW69q9BovDHMw79s8cvRd7Ll1YXlR3rNkhUnHL2wDI9G5A3Zxdl.VG.65._.72RjL mcpWBe3x_RHQ2ozY3NRg_TzG_lQr13WdM.3qJJZhVfIovY55yHBtPNNUVRUIuEDqaoPbI3886jpo 4XI_BZgHG_5vimhf_Tw0ZIi5dsRzKtuyPOb7EdYsF8nQOkwdESmfb1.52s8D_elU7Q2YA42lZqyA vXGTDOdbO5vMUkWFRUhHG78Sigi6kc1QosTFedbYAPoVYps5Hn7384HmohavQmkULg6f1YzHO9er OYlqFapeNn6oc_FNnk9c3AHN9uOhvMCvpJhAdHLGnWTC5QJCaWBcIC.4gXAl_wMZsd3p_W_eZHCI 0oXckIvevtVkDRTLAl5DMdOZ02.oC2w8tnreI3iVYzBz8BZ8KZKE76p5YIRfppiljAQ6o74em3Sn p2KfTGKl4ciei55s7WPzmOmwHW86nKGz7mE8lAZI0ZMW7UwhlOMm.jCLs6gfe7OUhoy3_FnhTiJD he0xMU8XRxHyxx57l_GzrfN6xkd0MTCpabEt2uIIUSXQ2oMdCMqUfY5ccOzhdWlv1NsRNkrhL1HR NgQI2t6BR3MAZt2Rofm1VJvXrChHJwmihfDcE3mVzWlVsdq.IQrJI3pFjGLZQVquMhysMZXpDMQL Rc4Kg4oUH6oe4AFd0owyDPKJvCfuzFxETYUtLd8oscnQXLH9aKvfU8we.4L76pggq5OSc029cnfG 9.5cZRqty_iamWkhUB6SDjDuNDooqizk2tHMTx0nopKtcvw5_tRZjUsFEpTEhVLGX2kwChbXeMUQ SZtEdqaghMjbDTCUSA0opzPd.ETv0qRc7O93J0KNse68Wm49DfsWSboaE5kesB3RWZmNfnqbaZ9k CtCjrY7Fo4F8QHW04C798V107cieiAiUp8LJT.AYOm.SLDuy4C5YJ_madgqSIygglg_WfVWVYiqq JQcSkFRSUnjId2AQ1GX7OhRbgcTCO.PJ7SmNO5k9DFGvBs566fjPY3jSyvTic2AX.kdXMyZOJ3Rc cgWeEot5NqchngiHQoPbdNj.e9Ge11hnnwP6JiksTknROREg7dM2kXU9kybLo9gZaTAHRYpmmrEZ gfH96ISy3T0SvmbZqpUNdFNAvSHnrQsCshG81Fva3jadcER.LrAB8NtCsdTeRsOC221SC2LsqYZe LK606kjeTVyFbYkC9EHUf7nN._ohNlKBgRaErJRzIijNZ_1esdwBXCpyNmKw9wgAqQF5MMuCpIyV wau.ycRfzcZhKl8cPErU5e3j0Y4jP38QVU9dz0wIl6Wg8RLzGxZW4QW.z7lmqkAPrsZuoM4GB4AH _q1rdw0qP X-Sonic-MF: X-Sonic-ID: fb29be42-860e-41ea-b4a9-2c43251f9828 Received: from sonic.gate.mail.ne1.yahoo.com by sonic314.consmr.mail.ne1.yahoo.com with HTTP; Sun, 12 May 2024 06:54:50 +0000 Date: Sun, 12 May 2024 06:54:46 +0000 (UTC) From: Naveed Iftikhar To: Julien Rouhaud Cc: "pgsql-admin@postgresql.org" Message-ID: <723188499.1574849.1715496886749@mail.yahoo.com> In-Reply-To: References: <89AA09AC-A627-4EAB-8B0C-0EE184BD56A2@elevated-dev.com> <15DE7820-429C-4163-BC59-E7608CF228B8@elevated-dev.com> <808751752.1562387.1715492644219@mail.yahoo.com> <160028138.1567187.1715493876270@mail.yahoo.com> Subject: Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1574848_224141028.1715496886748" X-Mailer: WebService/1.1.22321 YMailNorrin Content-Length: 2597 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1574848_224141028.1715496886748 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks a lot Julien.=C2=A0 Best Regards=C2=A0-Naveed-=20 On Saturday, May 11, 2024 at 11:10:16 PM PDT, Julien Rouhaud wrote: =20 =20 On Sun, May 12, 2024 at 06:04:36AM GMT, Naveed Iftikhar wrote: > Hi Julien, > =C2=A0 Thanks, I think previous DBA has created=C2=A0credcheck extension.= How can I remove or bypass or create the user with valid until ..=C2=A0 ev= en I provide the valid until but still getting the error. You should look at the documentation for the exact syntax to use: https://github.com/MigOpsRepos/credcheck =20 ------=_Part_1574848_224141028.1715496886748 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Thanks a lot Julien. 

Best Regards 
-Naveed-


On Saturday, May 11, 2024 at 11:10:16 PM PDT, Julien Rouhaud <rjuju123@gmail.com> wrote:


On Sun, May 12, 2024 at 06:04:36AM GMT, Naveed Iftikhar wrote:

> Hi Julien,
>   Thanks, I think previous DBA has created credcheck extension. How can I remove or bypass or create the user with valid until ..  even I provide the valid until but still getting the error.


You should look at the documentation for the exact syntax to use:
https://github.com/MigOpsRepos/credcheck



------=_Part_1574848_224141028.1715496886748--