MEAPSA

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.

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

Units

Introduction min
Describe Active Directory and Azure Active Directory min
Describe authentication and identities min
Describe Security Principals min
Describe database and object permissions min
Explain execute as user min
Explain the policy of least privilege min
Exercise: Authorize Access to Azure SQL Database with Azure Active Directory min
Knowledge check min
Summary min

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.