Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-03 : 08:00:36
|
| Dick writes "I have a table that contains system user information such as user name, login, password etc.create table tbuser(LoginName varchar(20) NOT NULL,UserName varchar(60) NOT NULL,Password varchar(20) NULL,bActive bit default(1) NOT NULL)On the query analyser or any query tool, we can see the password in plain text. Is there any method to change the field type so that it can not display plain text.I am using my vb code to encrypt the data before updating and vice versa to decrypt the data." |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-03-03 : 10:34:36
|
| Search here for encrypt/decrypt....it'll give you a few leads (of advice) to follow up on. |
 |
|
|
|
|
|
Field encryption