protect an auto trail trigger in a database

Let's say i have created a database and i want to distribute a copy of that database to a third party company, in order to fill in some data but not to delete any existing records. If the database contains a trigger, is it possible to protect that trigger from modifying or deleting it by the third party company? Is it possible to protect the database from deleting any existing records? I guess, if i can protect a trigger, then it is possible.

What is the appropriate way to give a database copy to the third party company? Can i just give them a copy of the mdf and ldf files?

January 31st, 2015 12:35am

You can implement row level security as described here: https://technet.microsoft.com/en-us/library/cc966395.aspx
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2015 1:24am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics