| From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
|---|---|
| To: | Naveed Iftikhar <naveed27c(at)yahoo(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option |
| Date: | 2024-05-12 06:00:30 |
| Message-ID: | ioj5zhbgfx5u3mjdnzlsmhoffqma2ch4mqctldeckxpdg2kukx@bsapfasejdth |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Naveed Iftikhar | 2024-05-12 06:04:36 | Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option |
| Previous Message | Naveed Iftikhar | 2024-05-12 05:44:04 | While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option |