852
Part VI: Securing Your SQL Server
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-defi ned 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 satisfi es your organization’s security requirements.
c33.indd 852c33.indd 852 7/31/2012 10:01:25 AM7/31/2012 10:01:25 AM
http://www.it-ebooks.info