pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWhile creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option
6+ messages / 3 participants
[nested] [flat]
* While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option
@ 2024-05-12 05:44 Naveed Iftikhar <naveed27c@yahoo.com>
2024-05-12 06:00 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Julien Rouhaud <rjuju123@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Naveed Iftikhar @ 2024-05-12 05:44 UTC (permalink / raw)
To: pgsql-admin
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
Best Regards -Naveed-
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option
2024-05-12 05:44 While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Naveed Iftikhar <naveed27c@yahoo.com>
@ 2024-05-12 06:00 ` Julien Rouhaud <rjuju123@gmail.com>
2024-05-12 06:04 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Naveed Iftikhar <naveed27c@yahoo.com>
0 siblings, 1 reply; 6+ messages in thread
From: Julien Rouhaud @ 2024-05-12 06:00 UTC (permalink / raw)
To: Naveed Iftikhar <naveed27c@yahoo.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option
2024-05-12 05:44 While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Naveed Iftikhar <naveed27c@yahoo.com>
2024-05-12 06:00 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Julien Rouhaud <rjuju123@gmail.com>
@ 2024-05-12 06:04 ` Naveed Iftikhar <naveed27c@yahoo.com>
2024-05-12 06:09 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Julien Rouhaud <rjuju123@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Naveed Iftikhar @ 2024-05-12 06:04 UTC (permalink / raw)
To: Julien Rouhaud <rjuju123@gmail.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option
2024-05-12 05:44 While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Naveed Iftikhar <naveed27c@yahoo.com>
2024-05-12 06:00 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Julien Rouhaud <rjuju123@gmail.com>
2024-05-12 06:04 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Naveed Iftikhar <naveed27c@yahoo.com>
@ 2024-05-12 06:09 ` Julien Rouhaud <rjuju123@gmail.com>
2024-05-12 06:20 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Tom Lane <tgl@sss.pgh.pa.us>
2024-05-12 06:54 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Naveed Iftikhar <naveed27c@yahoo.com>
0 siblings, 2 replies; 6+ messages in thread
From: Julien Rouhaud @ 2024-05-12 06:09 UTC (permalink / raw)
To: Naveed Iftikhar <naveed27c@yahoo.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option
2024-05-12 05:44 While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Naveed Iftikhar <naveed27c@yahoo.com>
2024-05-12 06:00 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Julien Rouhaud <rjuju123@gmail.com>
2024-05-12 06:04 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Naveed Iftikhar <naveed27c@yahoo.com>
2024-05-12 06:09 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Julien Rouhaud <rjuju123@gmail.com>
@ 2024-05-12 06:20 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 6+ messages in thread
From: Tom Lane @ 2024-05-12 06:20 UTC (permalink / raw)
To: Julien Rouhaud <rjuju123@gmail.com>; +Cc: Naveed Iftikhar <naveed27c@yahoo.com>; pgsql-admin
Julien Rouhaud <rjuju123@gmail.com> writes:
> On Sun, May 12, 2024 at 06:04:36AM GMT, Naveed Iftikhar wrote:
>> 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
This is pretty rich, because not only is credcheck making up this
valid-until date on its own, but then it's objecting to what it
made up. 'Jan 31 2030' is a perfectly valid date according to
Postgres, and "require a VALID UNTIL option with a date beyond 120
days" is not an error that appears anywhere in core Postgres, even
if we somehow failed to do the implied date arithmetic correctly.
I think your answer is to remove that extension, preferably
with gloves and tongs.
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option
2024-05-12 05:44 While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Naveed Iftikhar <naveed27c@yahoo.com>
2024-05-12 06:00 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Julien Rouhaud <rjuju123@gmail.com>
2024-05-12 06:04 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Naveed Iftikhar <naveed27c@yahoo.com>
2024-05-12 06:09 ` Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Julien Rouhaud <rjuju123@gmail.com>
@ 2024-05-12 06:54 ` Naveed Iftikhar <naveed27c@yahoo.com>
1 sibling, 0 replies; 6+ messages in thread
From: Naveed Iftikhar @ 2024-05-12 06:54 UTC (permalink / raw)
To: Julien Rouhaud <rjuju123@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2024-05-12 06:54 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-12 05:44 While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option Naveed Iftikhar <naveed27c@yahoo.com>
2024-05-12 06:00 ` Julien Rouhaud <rjuju123@gmail.com>
2024-05-12 06:04 ` Naveed Iftikhar <naveed27c@yahoo.com>
2024-05-12 06:09 ` Julien Rouhaud <rjuju123@gmail.com>
2024-05-12 06:20 ` Tom Lane <tgl@sss.pgh.pa.us>
2024-05-12 06:54 ` Naveed Iftikhar <naveed27c@yahoo.com>
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