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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Regarding Password Encryption

Author  Topic 

rammohan
Posting Yak Master

212 Posts

Posted - 2008-01-21 : 10:35:58
Hi,
here i have a table which contains loginid n password. i want to save this password in encrypted format in my table. is there any way in sql server side to acheive this task.

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-01-21 : 11:15:57
Never encrypt your password. It means that someone can decrypt it.
Store the hash value for the password in the table and have the front-end application search the hash value instead.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -