From: Naveed Iftikhar <naveed27c@yahoo.com>
To: Julien Rouhaud <rjuju123@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option
Date: Sun, 12 May 2024 06:04:36 +0000 (UTC)
Message-ID: <160028138.1567187.1715493876270@mail.yahoo.com> (raw)
In-Reply-To: <ioj5zhbgfx5u3mjdnzlsmhoffqma2ch4mqctldeckxpdg2kukx@bsapfasejdth>
References: <CAFhgWoLAh18RdnqzZuFfZ-i7Zi_Z2iUUD2CwBJKRsYzWA__t+Q@mail.gmail.com>
<89AA09AC-A627-4EAB-8B0C-0EE184BD56A2@elevated-dev.com>
<CAFhgWoKb7nFhHteZC9x14t9i7WPvr1UBBuMvBGgtQ=d6-vjNsA@mail.gmail.com>
<15DE7820-429C-4163-BC59-E7608CF228B8@elevated-dev.com>
<808751752.1562387.1715492644219@mail.yahoo.com>
<ioj5zhbgfx5u3mjdnzlsmhoffqma2ch4mqctldeckxpdg2kukx@bsapfasejdth>
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-
On Saturday, May 11, 2024 at 11:01:04 PM PDT, Julien Rouhaud <rjuju123@gmail.com> wrote:
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=#create user svc_dba;ERROR: require a VALID UNTIL option
> postgres=#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 created user with just 'create user xxxx; and it worked. Please suggest
You (or your DBA) apparently configured the credcheck extension which prevents
you from creating a role without those requirements, so you have to either
comply with the requirements or remote the extension.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: naveed27c@yahoo.com, rjuju123@gmail.com
Subject: Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option
In-Reply-To: <160028138.1567187.1715493876270@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox