Update view without rights to the base table?

[phildude]

Hello, we want to have a view that users utilize to see data. There is a lot of logic that goes into the view so that they can only see their particular records. Is there any way to allow them to update data within the view, but not give them any access to the base table that the view is made from? If they have access to the base tables, they can see stuff that they shouldn't... Any thoughts?

Thanks!
Phil

 

[fluteplr]

I works that way automatically. If you give them update rights to the view but not the base table you will get the effect you want.