Post reply

Encrypt SSN in the database

  • November 2, 2005 at 9:14 am

    #89814

    All,

    We have a system whcih uses SSN as primary key and with no encryption.

    Any ideas on how to encrypt SSN in the database???

    Thanks in advance.

    Chris

  • November 2, 2005 at 9:21 am

    #601891

    First of all move the PK.

    Then, Protegrity has a fairly seemless system, albeit $$$ (http://www.protegrity.com/)

    Netlib has something as well: http://www.netlib.com/sql-server-encryption.shtml

  • November 3, 2005 at 5:07 am

    #602093

    As in, create an identity column, or a GUID column, and make it your PK.  Then you can have an encrypted SSN stored in exactly one place.  When you need to look up the records for a particular SSN, you can encrypt it in the client code and use it to match the stored encrypted SSN - then use the identity PK to link to the rest of the tables...

  • April 6, 2011 at 7:33 pm

    #1308342

    Hi i need help can you help me with SSN database even site that i can be getting it i will really appreciate if you can get back to my message.

    If any member can help me out i will be happy

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply