Vendors (like hotels & now airlines) love their add-ons. Oracle offers a data masking service for a decent charge, while Microsoft offers a native, dynamic data masking (DDM) service for contemporary versions of MSSQL.
http://www.oracle.com/technetwork/database/options/data-masking-subsetting/overview/ds-security-dms-2245926.pdf?ssSourceSiteId=ocomen
https://azure.microsoft.com/en-us/documentation/articles/sql-database-dynamic-data-masking-get-started/
http://searchsqlserver.techtarget.com/tip/An-introduction-to-SQL-Server-2016-dynamic-data-masking
Why not trim the strings at the application-side & go from there? Ohh, you need an identifier. How about using a tokenization service (e.g., Vormetric, SafeNet) and a more comprehensive crypto / KMS strategy?
No comments:
Post a Comment