August 8, 2001 at 4:24 am
Hello,
I have a user table with fields :
userid varchar(30),
password varchar(10)
How can I encrypt the password and store in password field? is there any function available or I will have to write my own encryption algorithsm in stored procedure?
Thanks.
August 8, 2001 at 4:31 am
If you do it with a stored procedure you're still sending it over the wire unencrypted. Depends on how much risk you can handle.
Andy
August 8, 2001 at 4:36 am
But then how do i encrypt the data. Is there any encryption function available? I dont mind sending data unencrypted but data should be encrypted when it is stored.
August 8, 2001 at 4:45 am
check this article
http://www.sqlservercentral.com/columnists/bknight/encryptfunction.asp
August 8, 2001 at 6:55 am
You might also try the Counterpane Labs site. Counterpane Internet Security was co-founded by Bruce Schneier, author of Applied Cryptography:
http://www.counterpane.com/labs.html
It has some algorithms and links to other cryptography sites.
K. Brian Kelley
K. Brian Kelley
@kbriankelley
August 8, 2001 at 11:48 pm
Thanks. Going to use Encrypt function.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply