Hiding the SSN/SIN numbers in the Postegre/MySQL

Use this forum to discuss desired new features for TimeTrex
Locked
retched
Posts: 43
Joined: Mon Jan 24, 2011 1:08 am

Hiding the SSN/SIN numbers in the Postegre/MySQL

Post by retched »

Is there a way that the SSN or SIN numbers can be better hidden? I looked at the dump for the tables and I can see the SSN/SIN numbers in plain-text stored in the tables. With these numbers being pretty important and the possibility that some might install this on a a web server, I think it's better that this is looked into and converted into a Hash value like the passwords are using the value given in the salt.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Hiding the SSN/SIN numbers in the Postegre/MySQL

Post by shaunw »

Passwords are encrypted with a one-way encryption, they can never be decrypted, so this would make storing SIN/SSN's useless if we did that as we would never be able to decrypt them to print them on tax forms.
Locked