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)
required interaction external entities. valid case—where external entities system interfaces require ssn. typically government, tax , financial.
ssn used ensure system-wide uniqueness.
ssn has become default foreign key used internally within enterprise, perform cross-system joins.
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
Post a Comment