How can i encrypt database on client machine ?

  • Hi expert,

    How can we secure database ,database object, schema & actual data on client's machine so that then user can not anyone of the them.

    is there any way of encryption all the object not only data in data column ?

    Thanks & Regards

    http://www.indiandotnet.wordpress.com

  • Short answer: You can't.

    If you are putting a database onto a client's machine, then their sysadmins can do anything to that database and there is no way you can prevent that. If the code is totally and completely confidential (not the common case) then host the database, don't distribute it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

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