Re: database security

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 05/08/02


From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Tue, 07 May 2002 19:46:35 -0600


There isn't anything built-in to do encryption, other than
some undocumented system stored procedures that probably
wouldn't be wise to use. You can write your own encryption
using the CryptoAPI. There is a link to a sample xp that
does encryption and some additional information on
encryption alternatives in this FAQ:
http://www.mssqlserver.com/faq/general-encrypt.asp
In terms of the DSN, the usual approach is to use DSN-less
connection so that it's in the application, not in an
external source.

-Sue

On Tue, 7 May 2002 11:16:50 -0400, "Michou"
<jcaruso2000@hotmail.com> wrote:

>Hi
>
>How do you protect sensitive data (like CC numbers)? Also, when an
>application needs a DSN (C++ app), is there a way to hide this DSN and the
>application can still have it, without being hardcoded, or without human
>intervention.
>
>Michel
>
>



Relevant Pages

  • RE: Unable to install SQL Server 2000
    ... I have seen similar problems when there is a DSN on the system has is ... configured with the Use strong encryption for data. ... This posting is provided "as is" with no warranties and confers no rights. ...
    (microsoft.public.sqlserver.setup)
  • Re: Concerning Java and SSL (fwd)
    ... I have heard by a wise guy, so I repost it here, hoping that I might ... another than SSL encryption would be used? ... PGP encrypted mails welcome! ...
    (SecProg)
  • Re: decipher
    ... It might be wise to simply ask the person who generated the file for ... >>> How did the algorithm encrypt the phone numbers? ... >> I dont know the algorithm, but it seems to be a very week encryption. ... > original string... ...
    (microsoft.public.fox.programmer.exchange)

Quantcast