encryption - Best Practices / Patterns for Enterprise Protection/Remediation of SSNs (Social Security Numbers) -


i interested in hearing enterprise solutions ssn handling. (i looked pretty hard pre-existing post on so, including reviewing terriffic automated "related questions" list, , did not find anything, not repeat.)

first, think important enumerate reasons systems/databases use ssns: (note—these reasons de facto current state—i understand many of them not good reasons)

  1. required interaction external entities. valid case—where external entities system interfaces require ssn. typically government, tax , financial.

  2. ssn used ensure system-wide uniqueness.

  3. ssn has become default foreign key used internally within enterprise, perform cross-system joins.

  4. ssn used user authentication (e.g., log-on)

the enterprise solution seems optimum me create single ssn repository accessed applications needing ssn info. repository substitutes globally unique, random 9-digit number (asn) true ssn. see many benefits approach. first of all, highly backwards-compatible—all systems "just" have go through major, synchronized, one-time data-cleansing exercise, replace real ssn alternate asn. also, centralized, minimizes scope inspection , compliance. (obviously, negative, creates single point of failure.)

this approach solve issues 2 , 3, without ever requiring lookups real ssn.

for issue #1, authorized systems provide asn, , returned real ssn. of course done on secure connections, , requesting systems never persist full ssn. also, if requesting system needs last 4 digits of ssn, ever passed.

issue #4 handled same way issue #1, though best thing move away having users supply ssn log-on.

there couple of papers on this:

it should noted ssns pii, not private. ssns public information acquired numerous sources online. said if ssns basis of db primary key have severe security problem in logic. if problem evident @ large enterprise stop doing , recommend massive data migration right now.

as far protection goes ssns pii both unique , small in payload, protect form of data no differently password 1 time authentication. last 4 of ssns used verification or non-unique identification highly unique when coupled data attribute , not pii on own. said last 4 of ssn can replicated in db open alternative use.


Comments

Popular posts from this blog

javascript - Enclosure Memory Copies -

php - Replacing tags in braces, even nested tags, with regex -