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 difficult.
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.
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
