Re: encrypting SQL Server data

2004-05-11 Thread Matt Robertson
>Does anybody have any experience or recommendations about what to use 
>or how to go about doing it?

http://developer.perthweb.com.au/textcrypt.html

--
---
 Matt Robertson, [EMAIL PROTECTED]
 MSB Designs, Inc. http://mysecretbase.com
---

--
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: encrypting SQL Server data

2004-05-11 Thread Tom Kitta
That is a public key cryptosystem, he needs symmetric key. You can use one
of the encryption functions on the
http://www.cflib.org

Plus functions there are free to use.

TK
http://www.tomkitta.com

[Tom Kitta]

 -Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 11, 2004 4:29 PM
To: CF-Talk
Subject: Re: encrypting SQL Server data

  >Does anybody have any experience or recommendations about what to use
  >or how to go about doing it?

  http://developer.perthweb.com.au/textcrypt.html

  --
  ---
  Matt Robertson, [EMAIL PROTECTED]
  MSB Designs, Inc. http://mysecretbase.com
  ---

  --
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: encrypting SQL Server data

2004-05-11 Thread Matt Robertson
Tom Kitta wrote
>That is a public key cryptosystem, he needs symmetric key

No, the original post didn't say that, and asymmetric key systems work in the scenario he provided.  Granted they are more trouble to deal with when used properly (i.e. the decryption key is kept off the server and input -- pasted in -- at the start of each work session), but the sacrifice in convenience is made up for by the increased security. 

Provided of course the users know not to do things like email someone the private key.

--
---
 Matt Robertson, [EMAIL PROTECTED]
 MSB Designs, Inc. http://mysecretbase.com
---

--
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]