Re: OT: password encryption (salt theory) - Mailing list pgsql-admin

From Tom Lane
Subject Re: OT: password encryption (salt theory)
Date
Msg-id 5500.1029991658@sss.pgh.pa.us
Whole thread Raw
In response to Re: OT: password encryption (salt theory)  (Tim Ellis <Tim.Ellis@gamet.com>)
Responses Re: OT: password encryption (salt theory)  (Tim Ellis <Tim.Ellis@gamet.com>)
List pgsql-admin
Tim Ellis <Tim.Ellis@gamet.com> writes:
> Can anyone explain to me why a salt is really a good idea or if, as I
> suspect, it was an idea with good intentions that really doesn't help
> anything?

I believe the original purpose was to make it less obvious whether two
Unix users had the same password.  (Alice reads /etc/passwd, notices
that her password entry is the same as Bob's, trivially logs into Bob's
account.)

The small range of salts in the original implementation was, well,
appropriate for machine resources of the day.  These days you want
a few more random bits in there.  But the idea is not wrong merely
because there are threats it doesn't guard against.

            regards, tom lane

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: DB Access Restrictions
Next
From: Oliver Elphick
Date:
Subject: Re: How to execute my trigger when update certain columns