Post reply

deny everyone to copy database files and attach database

  • September 12, 2007 at 12:46 pm

    #180959

    Hi,

    we have one SQL 2005 express database and Windows aplication name "Catalog". Database contains data about cars. Aplication users are ours business partners. We install aplication and database localu on ours busines partnerss workstation.

    I want to deny everyone to copy our database files and attach database on their SQL server.

    pls help  . thanks

  • September 25, 2007 at 7:04 am

    #735991

    Oliver,

    It's basically impossible. The best you can do is to encrypt the database content and use this encrypted database from the application. However, I'm not sure now what kind of encryption is supported in Express Edition.

    -- Erik

    -- Erik http://blog.rollback.hu

  • September 25, 2007 at 8:38 am

    #736045

    I agree with Erik. Once you've installed on someone's workstation, they can do anything to the file.

  • September 28, 2007 at 3:34 am

    #737053

    I also like to prohibit some user to restore the Payroll database in their machine and view everything..

    Can I encrypt the 'Salary' field only and write some trigger to encrypt/decrypt it while my 3rd party Payroll application accessing it. Apart from it, no one can view it apart from the SA user...

    We cannot alter the 3rd Payroll application as we hasn't the source code

    Can someone post the example to encrypt/decrypt the field and how the tigger can do it

    Many Thanks in advance:D:D:D:D

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

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