Postgres Pro
Downloads
Home   >   mailing lists

Re: Require details that can we set characters length of a password to a User account in PostgreSQL Database. - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Require details that can we set characters length of a password to a User account in PostgreSQL Database.
Date
Msg-id 99827ccbd034d98e1208d2fe0e9e0339d8fd7e70.camel@cybertec.at
Whole thread Raw
In response to Require details that can we set characters length of a password to a User account in PostgreSQL Database.  ("Sonai muthu raja M" <Sonaimuthu.Raja@sifycorp.Com>)
Responses Re: Require details that can we set characters length of a password to a User account in PostgreSQL Database.
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Sonai muthu raja M"
Date:
Subject: Require details that can we set characters length of a password to a User account in PostgreSQL Database.
Next
From: "Sonai muthu raja M"
Date:
Subject: Re: Require details that can we set characters length of a password to a User account in PostgreSQL Database.