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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.