Configure database authentication and authorization

Configure database authentication and authorization

Contrast authentication using Microsoft Entra ID, Windows Active Directory, and SQL Server authentication. Implement various security principals and configure permissions.

Administrator
Azure

Module Objectives

After completing this module, you will be able to:

  • Learn about authentication options for Azure SQL Database
  • Create various security principals
  • Configure permissions within a SQL database
  • Identify authentication and authorization failures

Units

Prerequisites

  • Ability to use tools for running queries against a Microsoft SQL database, either on-premises or cloud-based
  • Understanding of why security is a crucial part of database system planning
  • Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level
  • Experience creating and configuring resources using the Azure portal