Home > IT Answers > Development > How to encrypt a big list of sp’s at once
Grizo
5 pts.
 How to encrypt a big list of sp’s at once
Encrypt, SQL, SQL stored procedures, Stored Procedures Optimization
I want to encrypt a large amount of store procedures (around 4000)at once,so they wouldn't be able for the final user. As this operation needs to be done several times in the future and taking in consideration that doing this manually will take a long time, I'll like to know if there is a way to do this with some sql option, or a tip to create an sp to do it. Thanks in advance for your help.

Software/Hardware used:
SQL Server 2005
ASKED: November 17, 2009  7:52 PM
UPDATED: November 18, 2009  1:46 AM
RELATED QUESTIONS
Answer Wiki:
No there isn't. You have to do an ALTER PROCEDURE specifying the WITH ENCRYPTION option. Do keep in mind that this encryption is very easy to undo. There are plenty of freeware software packages out there to decrypt the procedures. It also makes things look very unfriendly to the DBA when you encrypt the procedures as DBAs don't want anything running against the database that they can't see.
Last Wiki Answer Submitted:  November 18, 2009  1:46 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _