Subscribe to this blog
Briefcase
Print
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 |
Microsoft Dynamics |
Microsoft CRM |
T-SQL |
SQL Server |
Microsoft SQL Server |
SQL Server 2000 |
SQL Server 2005 |
Security |
Database Security |
SQL Server Security
K. Brian Kelley - Databases, Infrastructure, and Security
IT Security, MySQL, Perl, SQL Server, and Windows technologies.
No comments.