I want to encrypt my site user passwords which r stored in a table Login so that when anyone wants to see the passwords he will see only encrypted not the actual one.But the admin can see the actual passwords by some means.I am using Sql server 2000and ASP as the programming language and my site is situated at VSNL india.So pls give me some solution for encryption and decryption also??
regards pankaj
This conversation is currently closed to new comments.
No matter what you do, if it is encrypted in the table, it will appear encrypted. You'll need to write a small VB app with the decryption routine for the admin to view the passwords.
The download of the encryption DLL is available on my website, www.pointweb.net.
Point is, what you put in the database is what you also see.
The essence of encryption in applications is that you should first encrypt data before you insert these in the database, and when getting the data from the database, you should decrypt it so as to view "human readable" data.
I suggest that you create encryption and decryption functions in your ASP code. This should help secure your database data aside from the security that the SQL database itself implements.
You may createyour own encryption algorithm or better yet, implement n-DES, there are lots of resources about this on the Net.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Encryption in Sql 2000
regards
pankaj