在SQL Server 2008中加密SSN的最佳方法是什么？ [英] What is the best way to encrypt SSNs in SQL Server 2008?

问题描述

我正在使用.NET 3.5和SQL Server 2008开发一个新的Web应用程序，需要存储一些社会安全号码。我一直在数据库加密方面做一些初步的阅读，这有点令人困惑。

I am developing a new web application using .NET 3.5 and SQL Server 2008 that will need to store some Social Security Numbers. I've been doing some initial reading on database encryption and it's a little bit confusing.

我会很高兴使用非对称密钥加密SSN，因为这样面向公众的应用程序一旦加密，就无法检索任何数据。我认为只有管理界面能够解密和显示数据。但是听起来SQL Server仅使用对称密钥来保护数据？

I would be nice to encrypt the SSNs using an asymmetric key, since that way the public facing application wouldn't be able to retrieve any of the data once it has been encrypted. I was figuring that only the admin interface would be able to decrypt and display the data. But it sounds like SQL Server only protects data using a symmetric key?

那么，在SQL Server 2008中加密SSN的最好方法是什么？奖金积分，如果你链接到一个好的教程或两个。

So, what is the best way to encrypt SSNs in SQL Server 2008? Bonus points if you link to a good tutorial or two.

推荐答案

你真的不想使用非对称加密，因为它是非常慢。相反，您将需要使用非对称密钥来保护对称密钥，然后保持对称密钥的方便。说实话，我会坚持使用SQL Server中的内容，而不是自己设计。一个非常好的开始在这里 http://dotnetslackers.com/articles/sql/IntroductionToSQLServerEncryptionAndSymmetricKeyEncryptionTutorial.aspx

You really don't want to use asymmetric encryption because it's very slow. Rather you'll want to protect a symmetric key with an asymmetric key, and then keep the symmetric key handy. To be honest, I would stick with what's in SQL Server rather than designing things yourself. A really good start is here http://dotnetslackers.com/articles/sql/IntroductionToSQLServerEncryptionAndSymmetricKeyEncryptionTutorial.aspx

这篇关于在SQL Server 2008中加密SSN的最佳方法是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！