On 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.
Technorati Tags:
CRM |
T-SQL |
Security |