Re: Need help for procedure

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

From: Andrew John (aj_at_DELETEmistrose.com)
Date: 04/11/04 

Date: Sun, 11 Apr 2004 18:45:18 +1000

Kamal,

Either:

Save it after adding "WITH ENCRYPTION".
This hides it from everybody (well everybody who doesn't have 5 minutes and access to google anyway).

Or:

Put up with SA being able to read it.
But use security permissions to limit other's access

Or:

Write an extended stored procedure instead ( in a .dll )

Regards
 AJ

"kamal" <skkamalh@rediffmail.com> wrote in message news:182b101c41f81$50bf40d0$a601280a@phx.gbl...
> How to store a procedue that was written by USER of sql
> server in encripted format
> if "SA" opens it should not in readable format
> and how to decrypt it

Relevant Pages

  • Re: Trying to find MS-DOS encryption utility
    ... will try to decrypt the file. ... Some Google searches seem to indicate that perhaps this ... cryptfile program uses the "Blowfish" algoritm. ... It then asked twice for the encryption password and would beep when ...
    (comp.os.msdos.misc)
  • How do I Use DPAPI to Encrypt and Decrypt Data (C#/VB.NET)?
    ... Use DPAPI to Encrypt and Decrypt Data ... The code below demonstrates how to call Data Protection API (DPAPI) ... In addition to encryption and decryption, ... public static string Encrypt ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Byte array to string and back - newbie question
    ... // Create a symmetric algorithm. ... This is done to make encryption more ... // Encrypt a string into a string using a password ... // Decrypt a byte array into a byte array using a key and an IV ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: CryptAPI(encryption/decryption)
    ... It seems like you're missing the Base64 decode step when trying to decrypt ... I misspelled the Private Key as Primary Key. ... Is there any variation in the encryption format in openssl compared to ... "Dylan DSilva " wrote: ...
    (microsoft.public.pocketpc.developer)
  • Re: Writing spaghetti code for obfuscation/encryption
    ... > undocumented opcodes and simple encryption? ... do the protection and distribution (I'll justify this later, ... This key was used to decrypt the main program code. ... So here's the scheme in action: Put disk in, ...
    (comp.lang.asm.x86)