Re: [HACKERS] Password policy

2008-01-22 Thread Patrick McPhee
On Wednesday 16 January 2008 08:32, Andrew Dunstan wrote: > ( Slightly OT - chkpass uses crypt(). Maybe that should be upgraded to > use md5 or some more modern hashing function. ) Some versions of crypt() will generate md5 hashes if you start the salt with $1$$. I know this to work on FreeBSD,

Re: [HACKERS] Password policy

2008-01-16 Thread Roberts, Jon
> -Original Message- > From: D'Arcy J.M. Cain [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 16, 2008 9:39 AM > To: Andrew Dunstan > Cc: Roberts, Jon; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Password policy > > On Wed, 16 Jan 2008 08

Re: [HACKERS] Password policy

2008-01-16 Thread D'Arcy J.M. Cain
On Wed, 16 Jan 2008 08:32:12 -0500 Andrew Dunstan <[EMAIL PROTECTED]> wrote: > >> I need to set a basic password policy for accounts but I don't see any > > Look at my chkpass type in contrib. There is a function to verify the > > password. It is just a placeholder now but you can modify it to do

Re: [HACKERS] Password policy

2008-01-16 Thread Andrew Dunstan
D'Arcy J.M. Cain wrote: On Tue, 15 Jan 2008 16:11:16 -0600 "Roberts, Jon" <[EMAIL PROTECTED]> wrote: I need to set a basic password policy for accounts but I don't see any documentation on how to do it. I'm assuming there is a way to do this, maybe even with a trigger. The policy would be

Re: [HACKERS] Password policy

2008-01-15 Thread D'Arcy J.M. Cain
On Tue, 15 Jan 2008 16:11:16 -0600 "Roberts, Jon" <[EMAIL PROTECTED]> wrote: > I need to set a basic password policy for accounts but I don't see any > documentation on how to do it. I'm assuming there is a way to do this, > maybe even with a trigger. > > The policy would be something like this:

Re: [HACKERS] Password policy

2008-01-15 Thread Andrew Dunstan
Roberts, Jon wrote: I need to set a basic password policy for accounts but I don't see any documentation on how to do it. I'm assuming there is a way to do this, maybe even with a trigger. The policy would be something like this: 1. Must contain letters and numbers 2. Must be at least 8 cha

[HACKERS] Password policy

2008-01-15 Thread Roberts, Jon
I need to set a basic password policy for accounts but I don't see any documentation on how to do it. I'm assuming there is a way to do this, maybe even with a trigger. The policy would be something like this: 1. Must contain letters and numbers 2. Must be at least 8 characters long 3. Must co