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 |
|
ywb
Yak Posting Veteran
55 Posts |
 Posted - 2005-10-14 : 11:48:43
|
| Hi,I have a user table that's now storing username and password in clear text. I'd like to replace the current password field with a new field that stores the password in hash format.This table is used in a web application. I'll modify my pages to hash the submitted password for comparison with the hash in the database. But is there a way to use DTS to hash the existing clear text password entries and populate into the new field?Thanks,ywb. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-14 : 16:23:25
|
| You don't need DTS for this, just issue an UPDATE statement to that column. I have a little application where you type in the key and the value that you want to encrypt using that key. Then I can copy the encrypted value to update my passwords. That's easy if you don't have that many passwords. If you do, then you'll probably need to create a small app which does similarly to what I have described except it'll actually update the database.Tara |
 |
|
|
|
|
|
Encrypt Password Field Using DTS?