Configure database authentication and authorization


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


  • 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.