Re: encrypting stored procedures

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/27/03 

Date: Tue, 26 Aug 2003 21:58:16 -0400

You can script out all the sp's and do a search and replace on the CREATE
PROCEDURE part to add WITH ENCRYPTION. Just make sure you have the source
stored away somewhere safe for future editing on your part. 

-- 
Andrew J. Kelly
SQL Server MVP
"Richard Douglass" <RichardD@arisinc.com> wrote in message
news:%23KoVhCDbDHA.2620@TK2MSFTNGP09.phx.gbl...
> I was just informed that I must encrpyt the stored procedures for our
> production database to prevent our customers from viewing and/or modifying
> them.  The WITH ENCRYPTION option works well but we hav 4000+ existing
> procedures.
>
> Any ideas on the easiest (yet secure) way I can lock down the code?
>
> Thanks!
> Richard
>
>

Relevant Pages

  • Copying encrypted stored procedures.
    ... I have several stored procedures, created in a development environment, ... using the 'WITH ENCRYPTION' clause. ... then executing that script on the target server. ...
    (comp.databases.ms-sqlserver)
  • Voynich script.
    ... Also there was a mention about mysterious Voynich script. ... The second principle were pictures always people tend to make as much signs as many letters ... what you see is an inferior data stream, which resemble normal. ... And also there are some words which are looking as sort of "vocabularies" for this encryption. ...
    (sci.lang)
  • Voynich script.
    ... Also there was a mention about mysterious Voynich script. ... The second principle were pictures always people tend to make as much signs as many letters ... what you see is an inferior data stream, which resemble normal. ... And also there are some words which are looking as sort of "vocabularies" for this encryption. ...
    (sci.misc)
  • Re: Protecting Source code of a perl script
    ... > administrator could crack the encryption with only a day's work. ... Running 'strings' may yield vital information ... contained in the script turned binary. ... of the script to *hide* the code is a weak way to *protect* the code. ...
    (comp.lang.perl.misc)
  • Re: php to perl translation
    ... I need the result of this script to store the password in out LDAP ... The mcrypt functions should be used. ... // Using thirdparty library for DES with CBC encryption ... Convert the plaintext string to multi-byte storage format; ...
    (perl.beginners)