Hugo Kornelis (3/12/2012)
...And if the view includes the WITH CHECK option, those people would also be unable to change active members to non-active members.
I am not sure to understand perfectly the WITH CHECK option. From microsoft, I found that "WITH CHECK option" is:
"Forces all data modification statements that are executed against the view to follow the criteria set within select_statement."
So, If I understand well, all column from the view are protected against updates, but you can delete any row from the view (if it does not have reference constraint) or insert a new row ( if the view covers all "not null" columns). Is that it? That could be neet...