Chapter 7. SQL Server Modeling Services – Security
The Modeling Services framework supports granular (row-level) and claims-based security, built on the folder pattern discussed in the previous chapter. It should be clear, however, that a wide range of other security facilities is available, depending on which platforms you involve in creating an application.
Modeling Services uses updatable views in conjunction with the folder pattern to protect the base tables and provide row-level security. A SQL Server view is essentially a named read-only query of one or more tables that you or an application can use with subsequent queries as if it were a table. ...
Get Beginning SQL Server Modeling: Model-Driven Application Development in SQL Server 2008 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
