Summary
It's essential to secure the database objects to prevent unauthorized access that may compromise data. SQL Server 2012 provides the ability to create user-defined roles for easier security management. Role-based security enables database administrators to standardize access control over databases and provide a higher degree of granularity of object permissions.
Role-based security is an integral part of the SQL Server security model. This chapter covered securables, and by now you can design, implement, and maintain a robust security model that satisfies your organization's security requirements.
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.
