July 31, 2002 at 7:21 am
Have a third party company creating some stored procs on one of our servers. However, I`ve tried viewing the scripts to see what they are doing but get the message telling me they are encrypted objects? How do they do that?
Andy.
July 31, 2002 at 7:30 am
Simple:
CREATE PROCEDURE foo WITH ENCRYPTION
If you own the source code, then ask for it, otherwise, you're stuck.
Simon, UK
July 31, 2002 at 7:32 am
Use WITH ENCRYPTION when creating the stored procedure.
Just check the syntax of 'CREATE PROCEDURE' in BOL.
July 31, 2002 at 7:34 am
Touche....
Just found a util that decrypts the encrypted SP`s....heh....
Andy.
July 31, 2002 at 8:18 am
Yep. The stored procedure encryption isn't very strong at all. It also makes you ask, "What's the point?" Someone has even gone to the point of putting the decrypt into a stored procedure as opposed to requiring a utility.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 31, 2002 at 8:58 am
I think its worth doing just to discourage casual tampering...if that matters. In general Im not found of any app that uses stored procs that I cant edit.
Andy
July 31, 2002 at 3:40 pm
What is the util? I found a couple on sqlsecurity.com but they were for SQL Server 7. I didn't really find anything too helpful for 2000.
I am planning to encrypt my team's stored procs and want to add the code to Source Safe, but it would be nice to know I could get back to the code, just in case!
July 31, 2002 at 5:50 pm
search google with "decrypt stored procedure"
Steve Jones
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy