以安全的方式在Sql server数据库中存储密码。

本文介绍了以安全的方式在Sql server数据库中存储密码。的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ 我正在处理我的网络项目。我希望以像哈希这样的安全方式存储用户密码，但我知道在密码被哈希后它无法转换回来。但在我的项目中我必须实现忘记密码和重置密码。重置密码没问题，但是当忘记密码的情况下，如何将存储的哈希密码转换为原始密码，然后邮寄给用户。 所以，我需要知道哪种Hashing技术或Algo对我的情况更好。I am working on my web project. I want to store user password the secure way like hashing, but i came to know that after the password is hashed it cannot be converted back. But in My project i have To implement Forgot password and reset password. Reset Password is OK but when the case of forget password came how would i convert the stored hashed password into the original password and then mailed to the user.So, I need to know which Hashing technique or Algo is better for my case.推荐答案-- Create database KeyUSE Hassan_Web_Project_DB;GOCREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Password123';GO-- Create self signed certificateUSE Hassan_Web_Project_DB;GOCREATE CERTIFICATE Certificate1WITH SUBJECT = 'Protect Data';GO-- Create symmetric Key - This is used to both encrypt and decrypt our dataUSE Hassan_Web_Project_DB;GOCREATE SYMMETRIC KEY SymmetricKey1 WITH ALGORITHM = AES_128 ENCRYPTION BY CERTIFICATE Certificate1;GO 现在通过加密插入Now insert by encryptingINSERT INTO dbo.User_Login (User_ID, User_Name, User_Password)VALUES (25665, 'mssqltips4', EncryptByKey( Key_GUID('SymmetricKey1'), CONVERT(varchar,'4545-58478-1245') ) ) 并通过解密来选择And select by decryptingSELECT User_ID, User_Password AS 'Encrypted User_Password',CONVERT(varchar, DecryptByKey(User_Password)) AS 'Decrypted User_Password'FROM dbo.User_Login; 这篇关于以安全的方式在Sql server数据库中存储密码。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！