At some class I attended years ago I was told that update, insert, or delete through a view was not a wise thing to do. I am aware that I can use a trigger to prevent this or I can include a GROUP BY clause in the view definition and include every column in the Select statement to prevent it. Before I do this I want to ask what the dangers are and what your opinion and experience has been.
Also, if I allow UPDATE but disallow Insert and Delete is that acceptable in your opinion?
Thx in advance.