Configure database authentication and authorization

Intermediate
Administrator
Azure

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

Learning 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

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