Re: Encryption

Thanks David.


"David Gugick" <david.gugick-nospam@xxxxxxxxx> wrote in message
news:%237MM5gwQGHA.4900@xxxxxxxxxxxxxxxxxxxxxxx
Rogers wrote:
Is there any way I can encrypt the stored procedure and that only I
can only decrypt it none of other user can do?

I can't use Ecryption reserve word becuase that can also be decrypted
through third party tool, is there any other way I can encrypt my
stored procedure with my own key or like that?

Thanks in advance.

There are some thrid-party solutions for object encryption. In general,
you should be working/developing your stored procs (and other objects)
using external files and version control software like PVCS or SourceSafe.
It's not advisable to edit objects directly in the database. If you use
one of the third-party solutions, that should help secure the objects, but
I don't know if those tools support decryption or a more permanent type of
encryption.

I just came across one of these tools today (I have no experience with the
product or affiliation with them):
http://www.sql-shield.com/



--
David Gugick - SQL Server MVP
Quest Software



.

Relevant Pages

  • 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)
  • Re: Which is more secure RC2 or RC4 ?
    ... Credit card info... ... If your application can decrypt the information (in order to send it ... one goofy solution may be to use public key encryption on ... decryption key on a separate computer (laptop). ...
    (sci.crypt)