Web Development

Ask something
Discussion Locked

Encryption in Sql 2000

0 helpful
5 replies

by panks55

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

5 replies

by limatik

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.

good luck.

This discussion is closed to new replies.