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 1s62KE-009hFu-0t for pgsql-admin@arkaria.postgresql.org; Sun, 12 May 2024 06:04:46 +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 1s62KB-009A0a-M0 for pgsql-admin@arkaria.postgresql.org; Sun, 12 May 2024 06:04:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s62KB-009A0R-AH for pgsql-admin@lists.postgresql.org; Sun, 12 May 2024 06:04:43 +0000 Received: from sonic320-21.consmr.mail.ne1.yahoo.com ([66.163.191.83]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s62K8-000cMg-Cd for pgsql-admin@postgresql.org; Sun, 12 May 2024 06:04:42 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1715493878; bh=I3BesinavvbffIajZf0iQW79zD8WMJ2hXfdv4z6UD3w=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=WkviXxm95khwFie8ondJdEXhgU4ph9ZbYdtuvwHK4SYrjuESr/Ny7dE1bymwW8VU+VWq7OpOWuDBbbOnkTiw+e/15hy2kh0SH05EU553VoZjVuXgHLVcrpwox72JEG45O+COH0cbivu28m4W1zue1ip0LUZVzNLp6ApXz0M8TNlD6iO4tDRCfOXz9orNz6jjluMYlHefxOMQ0IW5F8w09BUm0/xYa9PrDHMCUeb/TorUDB8uehyOp0QqpdITEKAv7XcAerj1uJDKWPIPmqvspEYIvUY2Ef73409AgRKdsCT5AHILOSqSViaIBxZTKjO3fgIVt8J4sIY/1bsLwF+C4Q== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1715493878; bh=++IzzhdP0djWLJ9PCaHxvFOeRqtFRNkIoiawHthodVd=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=ExzkpSHVGjHSkIFPzb6n7vf00ke6SdNmHYGX+9cgl17H7gCsNFoU4SBcWD0lYzjUQRgU76hoFEHG5JDarKRO7cvcoGkMbjE9oxePK9c3b8qEeDf+1eWSW8PnQIsq1WrO/T8a6jrqKrVTEvHlypIKMvMHdz2lcVP43NA6uODZDzB5LFuJJnkbSaoNw56P/6DS4Lo+k57jKHZ1abNqJVjD3qPHX2EoZHDkufQnuN1tYEwAlFRumxR2G3gUrGapzpsze1tiqdtNvbS5KF/qnIBws7qHPDvNSXQbUXxe9QYhA4X+0+FPXoi2ba9uCyDxQhwQt8tmf3w4bpw4abZAhyIiNA== X-YMail-OSG: lIhKQR8VM1nsETXPOEPJtocrjxSo4B5iEK7_l7oaEZNcXI.av2vJtdeknS1hBw1 mu.2.kBKVliIXWtpNgugLOPSqw3bmiWQXpzXd.SquoRUsGxispH2MHxC0DVNEwveTH03VicQHYNu iV6RzliH7cZk9Wtkow3VNKsup.55thZjhEk5tixw9c.TGnxIhy_Fj75fhrRN1qTYj7OkpgAUE4rt z6OSLK1JtJM7oLRlwoAMFyiRN_HJ9ELgzCiEoJIAfa4MVRUSuMIDFQscBpFPgI6y_oN0EV4yNWhL adn.LieS9wX5i_7Vo4ucCRvHLCQEp_imJkylCPJzIU0C4Z3pWfnnJolUEuaKONQuW1bS.cXBoiFN HvY11qF9UDnMiJET9jl8aNjEfjhrzggOiTxd.p1fSjTCALWINZiMt0ieNCJ7gfCTE3TLMVkxDp8U hAPKZdjxWYYEXv5dx1fwt3yBd5Dmm_5YTstfYdTcm3DdDQIwXP0.jgT39J8HYDOHIgTGmz4VM0s_ 6YJZ..JFN9b9Wc_ULLdVHCmRi3tl0WIThlI61k_qN3hC.cs7sUSI7adtduvHxSNDTk1RTaWcAH.l uFKgccBG0GEbQAQzJCNYgBhgUl6OSAFZ3_ZSxDRWHirHL03o0HWXulo_y9GxYjLTUKvmzih7_4MV mtfLFrMQMftW3h47FdDLxXAH88POK1zMrAAs53F2nhc_mjVOXJ_eeM8vXHfSdRwXWXuBncm56.g3 Cc8Fkp81cC78CduYU48VNLgE0Xqw7lattGWwErcny6uwwctmItHufFMjTgdmxsy.RmhLwBuay0jt S65kaQ5CE8LsWNnKG76AZDP05CS8zmW3N4PrZMqfM4UX7aj_GCNRVKEfxLxyJg_BuLkhm48vK0sp V.bPkLWXGCJBUo2_qBJV1vt18VSHYLsbcJWfe4WRhN_9hMt4QnKzOpO98Cxg01uAqGoEHaw5_K5s z6zNviBXf7nU1saK5S_BMB.zrdPwFfym5ZmYfJvvW8IfT9mp7GhhscBcM.6X2TfXJtiaKYugive. VfusklERfUm_Ii6_0YF34yvx._tACdp1GX6HQbMIXgiiUKjy9yyglcCs3MVbaBfl0KaVn57zUTDu jKi37cLzHh0JqcOg1nn8l6YoK8JKE0bhbZlZ8uvBYNDg3QnB_FSxwAli6YXInonFWHlx.FFkdjDf MG3oxQl5kjWkvPtdRGubAsXrRfcnwNhfp_YbKvTP6iUmwsQnRzGiQKZNyKNf0AaDJIgUtIWrhuhO djwO6oGofHfZzmqd8DwaMa6fIAmTDb2NbaiWDwcSkDrtJA9Wj9twpcCuI7uJB7IHtAPtqdFHkHQQ MacU3MHaZ._5bfjvirFVN_nycf0zDxY3AaNwX01mo3qFSz56quehBN2grP4qfQcbmfIoUPW2F6fU a7hK6FFXwMh2dYyMUeGE6Iw7XuNy3eu27Bf6eODJPzUEceCgRyYuaxK9TfV7LJnPvs4IKmtcMzlI 3OMbF08CkLWB05rAaDLKRb7lO7sWYAdhhWxy4zuOVr3vwJAIhnpiJDZ4Ug53vMJhVPmy0LPk8mvw XQzqgiMERJBugVKL77XqYk1V._.mLcMEVzfMC4Dy.inn0t3CpdN9VSNWshGW5zZ80P00oSrnJ5YE Xospdv2aC5cbpjaFDUCyegiAiYgxKh.xTRDUQtXrCSDSUbXvQpm1_xZl8xCXo3Z6DRcmiViImuOD whAhAR.klBUf31zgM_VUlQpslJKlI.DlC1CT50VAWoBCOMPio4O61LKjhL17dAkogX_QeC4yqA8D ry1fwkwNk5tKDJLJUMXHOrreoOWqjhFFExyRs8J47sQCLtw5MTxX.NCNPgy2gyhJVbRC4w1._1uV Y0MoHjdDkd2mvENQkZTiPa0DumUMMD8Z2Q6fODjCcs9S7WrmpMgxsBBlsIrgns954Vjm33D5VH9K 0Aw3DaJKsFLmFK1xqMLoch9ccF2.9.8c4cTTuCboTZXqjTuGOSixuYwCH3BNstZPMlMtBpPBv5ZQ ArNcfRJan7PBn2KljDDMnfn7gPMcAUgt45tJVWUWPh3fiprX29Yesnn6QrXEzds4Ds8cpLpXQIXr KCD2CzWOum1RiUU1ufkE42dHv30HYb9Rtzw0UBBFa3nO_Lz_1gYR76WOvCbLFVP3clB03otJt7ES QBo9SDw8IHVyw4G9bNJjnT8GnkpttrkAUXNp0U15ldsUd7jUUhmEIWn0KNgMrBrMW.ydiiqD1xWT u2b7jNYaVUcPzEr4TGQ1Ief_tKOP6o.tdWwxE7AayvtR9yro_.t6WOxH3EQruVC4Npg-- X-Sonic-MF: X-Sonic-ID: 727640b0-1276-42ea-9976-3e88b05fa055 Received: from sonic.gate.mail.ne1.yahoo.com by sonic320.consmr.mail.ne1.yahoo.com with HTTP; Sun, 12 May 2024 06:04:38 +0000 Date: Sun, 12 May 2024 06:04:36 +0000 (UTC) From: Naveed Iftikhar To: Julien Rouhaud Cc: "pgsql-admin@postgresql.org" Message-ID: <160028138.1567187.1715493876270@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> 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_1567186_1805815804.1715493876269" X-Mailer: WebService/1.1.22321 YMailNorrin Content-Length: 3970 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1567186_1805815804.1715493876269 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Julien, =C2=A0 Thanks, I think previous DBA has created=C2=A0credcheck extension. H= ow can I remove or bypass or create the user with valid until ..=C2=A0 even= I provide the valid until but still getting the error. Best Regards=C2=A0-Naveed-=20 On Saturday, May 11, 2024 at 11:01:04 PM PDT, Julien Rouhaud wrote: =20 =20 Hi, On Sun, May 12, 2024 at 05:44:04AM GMT, Naveed Iftikhar wrote: > Hi Experts, > I just trying to create a user in postgres and getting following errors > postgres=3D#create user svc_dba;ERROR: require a VALID UNTIL option > postgres=3D#create user svc_dba VALID UNTIL 'Jan 31 2030';ERROR: require = a VALID UNTIL option with a date beyond 120 days > How can I just get rid of this VALID UNTIL option b'coz in past I have cr= eated user with just 'create user xxxx; and it worked.=C2=A0 Please suggest You (or your DBA) apparently configured the credcheck extension which preve= nts you from creating a role without those requirements, so you have to either comply with the requirements or remote the extension. =20 ------=_Part_1567186_1805815804.1715493876269 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
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.

Best Regards
 -Naveed-=


=20
=20
On Saturday, May 11, 2024 at 11:01:04 PM PDT, Julie= n Rouhaud <rjuju123@gmail.com> wrote:


=20 =20
Hi,

On Sun, May 12, 202= 4 at 05:44:04AM GMT, Naveed Iftikhar wrote:
> Hi Exper= ts,
> I just trying to create a user in postgres and g= etting following errors
> postgres=3D#create user svc_= dba;ERROR: require a VALID UNTIL option
> postgres=3D#= create user svc_dba VALID UNTIL 'Jan 31 2030';ERROR: require a VALID UNTIL = option with a date beyond 120 days
> How can I just ge= t rid of this VALID UNTIL option b'coz in past I have created user with jus= t 'create user xxxx; and it worked.  Please suggest


You (or your DBA) apparently configured the credch= eck extension which prevents
you from creating a role wit= hout those requirements, so you have to either
comply wit= h the requirements or remote the extension.


=
------=_Part_1567186_1805815804.1715493876269--