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 |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2004-07-06 : 11:56:58
|
Prabahsh Nandan Kumar writes "How to Encrypt/Decrypt Data Objects (specially Tables/SPs) and use on the fly." |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-06 : 16:02:43
|
What do you mean by use on the fly? You have to be very careful when encrypting stored procedures. You can't decrypt them. So if you want to look at them, you won't be able to, so you'll need to save off a copy of each of them.Tara |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-07-23 : 06:16:34
|
i usually encrypt sprocs by including the with encryption option but I do this on QA where I can save the script. Like what Tara said, once encrypted, even the creator won't be able to view it. |
|
|
|
|
|