Creating readonly views in Sql Server -

Creating readonly views in Sql Server -

according msdn, views composed of simple selects automatically allow utilize insert/update/delete statements on table. there way prevent - tell sql server view readonly, , can't utilize modify table?

the best way remove update/delete/insert permissions on view.

apart create instead of trigger on view nil have updates silently fail or there quite few constructs create views non updatable. can pick 1 doesn't alter semantics or efficiency , violate it.

edit: below seems fit bill.

create view bar select top 100 percent x foo check alternative

sql-server views