Chapter 6. Securing SQL Server 2012
Exam objectives in this chapter:
Manage database permissions.
Troubleshoot security.
Audit SQL Server instances.
Microsoft SQL Server 2012 databases hold information that is critical for an organization. Databases can host confidential customer information or organizational information not for public disclosure. This chapter covers how to set up database permissions to ensure that database principals have appropriate rights. You learn how to troubleshoot security settings to ensure that appropriate access is possible and how to track specific actions that occur at the instance and database level by using SQL Server Audit.
Lessons in this chapter:
Get Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases 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.
