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 |
|
rammohan
Posting Yak Master
212 Posts |
 Posted - 2007-06-06 : 11:31:46
|
| hi, here i am developing a database in SQL SERVER200 for a project. in this i have a tbale say tbl_login, in this table i have 2 columns Id,Password.i want to insert the passwords in password column as ****** instead of original charecters i.e i want to store * in stead of character.so please give me a wayOne can never consent to creep,when one feels an impulse to soarRAMMOHAN |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-06 : 11:35:23
|
| You can't store * to hide passwords, but you can definitely store password hash to make them unreadable.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
rammohan
Posting Yak Master
212 Posts |
Posted - 2007-06-06 : 11:38:21
|
| Ok,Can u please Tell me The ProcedureOne can never consent to creep,when one feels an impulse to soarRAMMOHAN |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-06 : 11:43:44
|
| Peso has kindly posted few functions here for encryption. You can find them by searching the script library forum.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2007-06-06 : 13:34:00
|
| Depending on what you are working on you might want to consider a one-way hash. Here is an article that addresses this sort of thing: [url]http://www.15seconds.com/issue/000217.htm[/url]. However, if you just want to encrypt the password so you can retrive it and decrypt it, then look around here or do an internet search for storing passwords in a database.-Ryan |
|
|
|
|
|
|
Regarding Passwords in SQL SERVER