| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Sonai muthu raja M <Sonaimuthu(dot)Raja(at)sifycorp(dot)Com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Cc: | Sivaprahasam Dharman <Sivaprahasam(dot)Dharman(at)sifycorp(dot)Com> |
| Subject: | Re: Require details that can we set characters length of a password to a User account in PostgreSQL Database. |
| Date: | 2022-03-01 11:49:39 |
| Message-ID: | 99827ccbd034d98e1208d2fe0e9e0339d8fd7e70.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2022-03-01 at 08:18 +0000, Sonai muthu raja M wrote:
> Kindly help us to know that can we set characters length of a password to a User account in PostgreSQL Database.
>
> Please do the needful since the information require for auditing purpose.
There is no way to do that.
You can use the "passwordcheck" extension, but that will only work for clear-text
passwords.
Your only real option is *not* to use passwords in the database, but to authenticate
with an external service like Kerberos or LDAP. Then you can enforce the password
rules there.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sonai muthu raja M | 2022-03-01 12:46:25 | Re: Require details that can we set characters length of a password to a User account in PostgreSQL Database. |
| Previous Message | Sonai muthu raja M | 2022-03-01 08:18:44 | Require details that can we set characters length of a password to a User account in PostgreSQL Database. |