> In a nutshell, then, I'd like my users to be able to alter the data
> in the tables, but only the data that they can see in the views, and
> only in a way so it remains in their views after modification.
> Has anyone got any advice?
I've seen Veil suggested for problems like yours. It is a Post
This a row-level security style question.
Suppose I have a hypothetical warehouse database. In my warehouse
everything is stored in a crate. My customers are going to rent crates
from me. I'm going to provide a way that they can keep track of what's
in each crate. Because my customers are very se