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