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 |
|
sboshuis
Starting Member
2 Posts |
 Posted - 2012-07-27 : 08:09:39
|
| Hi,if data is encrypted with sym key and that key is protected with certificate in the SP you can decrypt data simply by- open key- decrypt by certificate- select with decryptbykeySo if you get access to sqlserver (e.g. server administrator) you just open up the SP and know how to read the encrypted data.How can one better protect this?Is encoding the SP the only way to go?Sander |
|
|
|
|
|
sp and encryption