Re: Obfuscating SQL stored procs

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Puopolo (john.puopolo_at_fastsearch.com.nospam)
Date: 02/02/05 

Date: Wed, 2 Feb 2005 11:28:59 -0500

Paul:

One thing you could do is have the real SP names in a resource file that you
encrypt. The application then reads the SP name (accessing it by number,
perhaps) from the resource file, decrypts it and then generates the call to
the SP.

John

"Paul Aspinall" <paul@aspy.co.uk> wrote in message
news:f47Md.205$89.134@fe3.news.blueyonder.co.uk...
> Hi
> I have developed a C# app which uses SQL Stored procs... which I plan to
> deploy as a single / low user version on MSDE.
>
> My SP's all have 'meaningful' names. However, as I want to protect my app
as
> much as possible, is it possible to 'obfuscate' the SQL SP names??
> I know I could do this manually, but then I may lose the 'ease of
> development' due to meaningless SP names...
>
> I already plan to encrypt the SP's themselves, but want to obfuscate the
> names also.
>
> I would, ideally, like to run my code through an obfuscator, and have it
> obfuscate code, and also obfuscate the SP's to a 'deploy' DB.
>
> Does anyone know of a suitable package??
>
> Thanks
>
>
> Paul
>
>

Relevant Pages

  • Re: Obfuscating SQL stored procs
    ... One thing you could do is have the real SP names in a resource file that you ... is it possible to 'obfuscate' the SQL SP names?? ... > I already plan to encrypt the SP's themselves, ... > obfuscate code, and also obfuscate the SP's to a 'deploy' DB. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Code protection
    ... Did you try to obfuscate it first? ... I would suggest you to use the tools accesible to the framework. ... solution you encrypt the dll, meaning that the file in the HDD is not longer ... a DLL, it's a data file. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: URL encryption
    ... use a httmodule, but the problem is that this solution just work for asp.net, ... Im using asp.net, coldfusion in my site. ... You cannot encrypt or alter URLs if your application requires them to ... If you want to obfuscate and "hide" the details of your application's ...
    (microsoft.public.inetserver.iis.security)
  • Re: how to hide javascript code?
    ... > Does it exist a way to encrypt or hide the javascript code on a webpage? ... You can obfuscate the code ...
    (microsoft.public.scripting.jscript)
  • Obfuscating SQL stored procs
    ... I have developed a C# app which uses SQL Stored procs... ... I already plan to encrypt the SP's themselves, but want to obfuscate the ... obfuscate code, and also obfuscate the SP's to a 'deploy' DB. ...
    (microsoft.public.dotnet.languages.csharp)