首页 > 代码库 > 数据库数据加密与解密
数据库数据加密与解密
MVC的练习之旅,将要进入另一个阶段了,将增加会员功能。在进入之前,一些准备工作需要做的。一步一个脚印吧。设计会员功能,其中密码字段,Insus.NET想对它进行加密。就因这个加密,还得花上一些时间来整理。
Insus.NET参考MSDN网站,列出数据库加密解密例子(以下是在SQL Server 2012进行):
--创建数据库主密钥CREATE MASTER KEY ENCRYPTION BY PASSWORD =‘Pass#Tutorial#word‘GO
--创建证书CREATE CERTIFICATE PasswordCert with SUBJECT = ‘Member Password Certificate‘GO
--创建非对称密钥CREATE ASYMMETRIC KEY PasswordAsymmetric WITH ALGORITHM = RSA_2048 --{ RSA_512 | RSA_1024 | RSA_2048 } ENCRYPTION BY PASSWORD = ‘Pass#Tutorial#word‘; GO
--创建对称密钥CREATE SYMMETRIC KEY PasswordSymmetric WITH ALGORITHM = AES_256 --{ AES_128 | AES_192 | AES_256 | TRIPLE_DES_3KEY } ENCRYPTION BY PASSWORD = ‘Pass#Tutorial#word‘;GO
--由证书加密对称密钥CREATE SYMMETRIC KEY SymmetricByCert WITH ALGORITHM = AES_256 ENCRYPTION BY CERTIFICATE PasswordCert;GO
--由对称密钥加密对称密钥OPEN SYMMETRIC KEY PasswordSymmetric DECRYPTION BY PASSWORD=‘Pass#Tutorial#word‘CREATE SYMMETRIC KEY SymmetricBySy WITH ALGORITHM = AES_256 ENCRYPTION BY SYMMETRIC KEY PasswordSymmetric;GO
--由非对称密钥加密对称密钥CREATE SYMMETRIC KEY SymmetricByAsy WITH ALGORITHM = AES_256 ENCRYPTION BY ASYMMETRIC KEY PasswordAsymmetric;GO
创建之后,会要相应的数据库之下,显示如下:
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。