Hi katit;
By default, database views are read-only. You can make a db view updatable by following this guide. http://blogs.msdn.com/b/alexj/archive/2009/09/01/tip-34-how-to-work-with-updatable-views.aspx - http://blogs.msdn.com/b/alexj/archive/2009/09/01/tip-34-how-to-work-with-updatable-views.aspx
In DevForce, to limit access to entities, you can
1. Change the member visibility - http://drc.ideablade.com/xwiki/bin/view/Documentation/model-member-visibility - http://drc.ideablade.com/xwiki/bin/view/Documentation/model-member-visibility
2. Add save authorization attribute - http://drc.ideablade.com/xwiki/bin/view/Documentation/model-edm-designer-properties#HEntityEDMProperties - http://drc.ideablade.com/xwiki/bin/view/Documentation/model-edm-designer-properties#HEntityEDMProperties
3. Intercept the save on the server by inheriting from EntityServerSaveInterceptor class and override its AuthorizeSave method. http://drc.ideablade.com/xwiki/bin/view/Documentation/save-lifecycle-server#HInterceptortemplatemethods - http://drc.ideablade.com/xwiki/bin/view/Documentation/save-lifecycle-server#HInterceptortemplatemethods
Hope this helps.
|