Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

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
Free download pdf