Implementing Access Controls on SQL Server Data

Most relational databases provide fine-tuned access controls to various objects in the database, including tables, views, and indices, but lack the support for individual row (record) access control. In the “Implementing Access Controls on SQL Server Data” article I wrote for InformIT, I'm describing how you can implement record-level access control in any relational database that supports triggers and separate access controls for views and underlying tables.