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 |
|
swathigardas
Posting Yak Master
149 Posts |
 Posted - 2009-02-17 : 01:19:04
|
| How can i encrypt and decrypt a password column in sql 2000...I dont have any clue on this.. Can any one help me out..Thanks before hand-Swathi |
|
|
sridhar.dbe
Starting Member
34 Posts |
Posted - 2009-02-17 : 01:59:00
|
| Hi,According to my knowledge-you need to create/use some algorytmn to encrypt your password independent of the Database.-one method is to say create an extended stored procedure which implement the MD5 algorytmn and use this to encrypt any passwords. Then just store the encypted verion in the database and then always test the encrpted version of the password against the stored value ... |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2009-02-17 : 08:36:07
|
| For passwords, you only need a one-way encryption algorithm. You should never need to decrypt a password, as you need only compare the encrypted strings for validation.There are lots of one-way encryption methods available. I have an SQL based one if you want it.________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
|
|
|
passowrd encryption