Azure SQL Security: Understanding Access and Authentication (Ep. 2) | Data Exposed

preview_player
Показать описание
In this episode of Data Exposed Live, Andreas Wolter and Mirek Sztajno (Azure SQL Security Program Managers) guide you through two fundamental areas of securing a SQL Database: Authentication and Access Management. Covering basics and also advanced concepts, this session is meant to help both beginners and experienced users in designing security for their SQL estate.

0:00 Show begins
0:40 Introductions
2:00 Overview
3:20 Azure Active Directory Authentication
10:20 Azure AD authentication with Azure SQL DB
13:46 Demo: Connecting a guest user to Azure SQL using multi-factor authentication
21:50 Role-Based Access Control (RBAC)
27:45 SQL Roles & Permissions
36:40 Demo: Applying least permissions in a scalable manner, using database roles
50:30 Row-Level Security
57:20 What's next

✔️ Resources:
Azure Active Directory:

Azure RBAC:

Permissions, Roles, and Schemas:

Security:

📌 Let's connect:

#AzureSQLSecurity​ #AzureSQL​ #SQLServer
Рекомендации по теме
Комментарии
Автор

Great job Mirek, Andreas, and Anna! Really appreciate the information!

vanto
Автор

Very useful presentation ! Very good !

C_G_
welcome to shbcf.ru