SQL-Server密码加密 [英] SQL-Server Password Encryption
本文介绍了SQL-Server密码加密的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在为刚开发的网站创建一个数据库,但是我需要加密我的密码。
I am creating a database for a website I've just developed but I need to encrypt my passwords.
我从来没有加密密码,不知道该怎么做,我搜索了google和很多网站,但他们所做的只是让我感到困惑。
I've never encrypted passwords before and I don't know how to do it, I've searched google and a lot of websites but all they do is confuse me.
这是我的Sproc:
CREATE TABLE USERS(
Username Nvarchar(200) PRIMARY KEY NOT NULL,
Password Nvarchar(200) NOT NULL,
EmailPassword Nvarchar(200) NOT NULL,
UsernamePassword Nvarchar(200) NOT NULL
)
CREATE TABLE Usernames(
Username Nvarchar(200) FOREIGN KEY(Username) REFERENCES USERS(Username),
Usernames Nvarchar(300) NOT NULL,
Description nvarchar(500)
)
CREATE TABLE Emails(
Username Nvarchar(200) FOREIGN KEY(Username) REFERENCES USERS(Username),
Passwords Nvarchar(300) NOT NULL,
Description nvarchar(500)
)
CREATE TABLE Passwords(
Username Nvarchar(200) FOREIGN KEY(Username) REFERENCES USERS(Username),
Usernames Nvarchar(300) NOT NULL,
Description nvarchar(500)
)
我想加密包含NOT NULL的列接受用户名列
I would like to encrypt the columns that contain NOT NULL accept the username column
推荐答案
不要存储密码直接,甚至不加密。使用盐渍哈希。
Dont store the password directly, not even encrypted. Use a salted hash.
退房
- Secure Salted Password Hashing - How to do it Properly
- Strong Password Hashing with SQL Server
这篇关于SQL-Server密码加密的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文