显示密码字段在SQL Server中已加密 [英] Display Password field as encryped in SQL Server

问题描述

我有一个表，TblUserLogin，字段为LoginID int，密码varchar(50)，LoginUserName varchar(150)，名称varchar(100).我的要求是，无论何时我们在表中使用selectstatement时，我们都可以看到输入的密码(这是敏感信息).通过它们的任何方式，我们都可以加密密码字段，以便无论何时使用selectstatement，该信息都将以加密的方式显示，并且不会影响正在访问密码字段或插入新密码的代码.简而言之，当使用selectstatement从Management Studio访问密码字段时，密码字段显示为已加密，但是通过编程方式访问密码字段时，它将返回实际密码(未以加密方式).

I am having a table , TblUserLogin with field LoginID int ,Password varchar(50) , LoginUserName varchar(150), Designation varchar(100). My requirement is that , when ever we are using selectstatement to this table we are able to see the password which is entered (Which is a sensitive information). Is their any way so that we can encrypt the password field so that when ever we use selectstatement ,that information will be seen in encryped way and will not affect the code which is accessing the password field or inserting new password.In simple words when "The password field shown as encryped when it is accessed from management studio using selectstatement, but when programatically it is been accessed it return the actual password( Not in encrypted way).

推荐答案

看看这篇文章，您会发现它很有帮助
密码存储:操作方法. [

Take a look at this article. You might find it helpful
Password Storage: How to do it.[^]

这篇关于显示密码字段在SQL Server中已加密的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！