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 |
|
duncanwill
Starting Member
20 Posts |
 Posted - 2009-11-26 : 12:33:32
|
| Hi,I have a requirement given to me to encrypt a fields data within an existing table. We need to be able to read and write the data (i.e. encrypt it into the database and decrypt it back out - so only the storage of the data is encrypted).I do not have any control over the application layer - so I cannot encrypt the data before it reaches the database, but when the data reaches the DB then it needs to be encrypted. I realise this is not an ideal situation - but it is the one I am faced with! Ideally I would be able to implement the encryption in the .NET code and pass it through 'as is' to the DB for storage... but I can't.Does anyone know any third party (ideally freely available) algorythms that can be called from a Proc or Trigger - i.e. drop into the shell and execute an exe or similar and then insert the data. Would i be able to use RC4 or similar for example directly with SQL?Any help appreciated - if I am barking up the wrong tree (or just barking mad) please let me know. |
|
|
|
|
|
Encrypting a field via SP or Trigger