Configure database authentication and authorization

Intermediate
Administrator
Azure

Contrast authentication using Azure Active Directory vs Windows Active Directory vs 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

Prerequisites

  • Basic understanding of Active Directory.
  • Understanding of why security is a crucial part of database system planning.
  • Ability to write code in the SQL language, particular the Microsoft T-SQL dialect, at a basic level.
  • Experience creating and configuring resources using the Azure portal.