Re: create trigger in postgres to check the password strength

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

2017-02-03 17:17 GMT+01:00 Pavel Stehule <pavel.stehule@xxxxxxxxx>:

Hi

2017-02-03 16:14 GMT+01:00 PAWAN SHARMA <er.pawanshr0963@xxxxxxxxx>:

Hi All,

Is this possible to create trigger in postgres to check the password strength( like char should be min 8 character)  while to creating  user or role with password.

If it possible can you please share the script with me..

yes, it is possible (with a extension)

http://paquier.xyz/postgresql-2/postgres-module-highlight-customize-passwordcheck-to-secure-your-database/

You can use contrib extension

 https://www.postgresql.org/docs/current/static/passwordcheck.html

Regards

Pavel

Regards

Pavel

 

-Pawan