http://www.sqlservercentral.com/blogs/brian_kelley/2007/04/09/microsoft-crm-security-internals/ Printed 2014/10/01 06:39AM
Microsoft CRM Security Internals
2007/04/09On the Microsoft Dynamics CRM Team Blog, Jay Grewal has posted information about the CRM Security Model Internals.
CRM is an interesting application for DBAs because it does use row-level security. It's a bit more complex than most row-level security models in that there are access checks and privilege checks. Access checks can be overridden but privilege checks cannot. There's information about how all this works and how they've done some optimizations for retrieving sets of data.
Microsoft Dynamics |
Microsoft CRM |
SQL Server |
Microsoft SQL Server |
SQL Server 2000 |
SQL Server 2005 |
Database Security |
SQL Server Security