O'Reilly logo

Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases by Peter Ward Orin Thomas and boB Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required