0

Is there any built in feature in SQL server that allows dual control updates, deletes and inserts?

What I mean by dual control is that it requires any two users to collude in order to alter the database. However, they'd be able run selects just fine.

Is there an inbuilt feature that allows this or will I have to roll my own?

3

Ah. No. And i do not think there is any other database doing that. 4+ eyes is an application layer feature.

2
  • Agreed. Let your app do that.
    – shiitake
    Oct 14 '10 at 13:54
  • +1 - there's nothing in SQL Server that will do this.
    – Brent Ozar
    Oct 18 '10 at 1:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.