Friday, June 18, 2010

SQL Server and Row-Based Security

Here's an interesting article on how one company implemented row based security in SQL Server.  I'm considering using this technique (or some variation) to replace our application's implementation of 'partitioning', 'roles' and 'data synchronization to hardware'.  It would have the great benefit of replacing 3 different patterns, each of which has its own unique complexities with just one pattern.

No comments: