Post reply

Obfuscation in SQL 2000

  • February 19, 2004 at 3:22 pm

    #359116

    Hello,

    I work for a company that is looking into encrypting data such as credit card numbers in a SQL 2000 database.  I know Oracle has a "hacker proof" encryption algorithm built into dbms_obfuscation toolkit.

    Short of writing our own algorithm (or buying a 3rd party encryption package) does anyone have any idea if SQL 2000 has something built in to encrypt/decrypt data?

    Thanks in advance for your help.

     

    AJR

  • February 19, 2004 at 4:09 pm

    #494816

    I know protegrity software make software something on those lines using extended procs.

  • February 19, 2004 at 4:48 pm

    #494823

    Thanks for your response.  Leads me to believe that SQL 2000 cannot encrypt data internally.  If anyone knows otherwise, please fill me in.

    Thanks,

    AJR

  • February 20, 2004 at 1:51 am

    #494877

    Take a look at BOL: Microsoft® SQL Server™ encrypts or can encrypt: Any data sent between the client and the server as network packets etc etc, but has no available algorithms to encrypt data in the Db !. Regards, j.

  • February 20, 2004 at 9:25 am

    #494951

    SQL Server has no documented internal mechanism for encrypting/decrypting data in this manner. Microsoft will point you to the use of third parties. Protegrity is one such vendor.

     

    K. Brian Kelley
    @kbriankelley

  • February 20, 2004 at 10:26 am

    #494974

    Thank you for all the responses!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply