Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

875


Chapter 35: Row-Level Security


35


Summary


SQL Server has a solid reputation for security, but it lacks row-based security. If the
database is well architected with a carefully implemented abstraction layer, then adding a
custom row-based security schema is not diffi cult.

This concludes Part VI, “Securing Your SQL Server,” which is so critical for production
databases. SQL Server security is based on matching privileges between principals and
securables, and a chapter was devoted to each side of the equation.

c35.indd 875c35.indd 875 7/31/2012 9:59:41 AM7/31/2012 9:59:41 AM


http://www.it-ebooks.info
Free download pdf