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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy