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 |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2007-06-18 : 16:08:51
|
| Hi,Can anyone please tell me how to write a stored procedure that encrypts data that is saved in database and decrypts it when displayed to users in screen?Also, i need to perform a check to see if the data in the database was encrypted or not as there is some data entered in the database already.Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-06-18 : 16:54:11
|
| I made a RC4 encryption/decryption routine.Please search Script Library.Peter LarssonHelsingborg, Sweden |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-06-18 : 16:57:40
|
| personally, i don't think that data should be encrypted/decrypted at the database. if you do, then unencrypted data gets sent across the wire to your client.A better solution (imho) is to encrypt at the client - but that is just my 2 cents.-ec |
|
|
|
|
|
|
decrypt/encrypt