Post reply

Data Encryption

  • December 29, 2004 at 11:47 pm

    #162965

    Hi,

     

    I am looking for way to encrypt data in a table. I have seen the encrypt function for inserting the data into a table, and when I select that data only the first letter seems to return.

    My question, how can I do it such that if anyone gets hold of the database and is able to resotre it on another server an access the table they will only see encrypted data, but when I do my select how do I decrypt it so that the whole value is reurned?

     

    Thanks in advance.

     

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • December 30, 2004 at 5:12 am

    #535380

    Iam afraid any such solution is inbuilt in SQL server.

    I would suggest that you can create a User defined function for encrypting and decrypting the data .

    Kindest Regards,

    Sureshkumar Ramakrishnan

  • December 30, 2004 at 11:05 am

    #535437

    Agreed, go with a UDF or do the encrypt/decrypt at the application level. There is no built-in capability within SQL Server 2000 without resorting to custom code or a 3rd party product. However, encryption is currently in the beta for SQL Server 2005.

    K. Brian Kelley
    @kbriankelley

  • December 30, 2004 at 6:08 pm

    #535479

     

    Thanks for the insight....I guess I will be going with a UDF.

     

     

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • December 31, 2004 at 9:25 am

    #535514

    There are 3rd party products like Protegrity to help with this.

     

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

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

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