Post reply

Read only database transfer...

  • December 4, 2014 at 4:44 am

    #299212

    Hi,

    I have an inter-company problem.

    The one company gathers data into a SQL database hosted within their secure network and now one of the companies (that they are contracted to gather the data for) wants a backup of the data or a replicated database to be able to be placed onto a external HDD or different SQL server on their own network and server.

    The catch is that to maintain their data security the original company doesn't want the company that is receiving the data to be able to edit the data. They are concerned that someone might change the data and claim that the data that they gathered is incorrect.

    Is there a way to ensure the SQL database remains entirely read only?

    Regards

    Christy

  • December 4, 2014 at 5:21 am

    #1762682

    nope.

    if you give the data away, you give up control of the data.

    if you give someone a backup of the data, it's a copy. once they restore it, they can do anything they want to the data;

    to maintain read only you would have to host the data yourself, and give them remote access via a user that you've put in the role db_readonly, for example.

    even then, if they can read it, they can copy it, and thus modify copies of the data.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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