Explore the intricacies of Row Level Security (RLS) in SQL Server 2016 and beyond in this 51-minute conference talk from PASS Data Community Summit. Learn the fundamental patterns for implementing RLS, enabling developers and DBAs to precisely control access to sensitive data in specific tables. Gain insights into scaling RLS solutions for enterprise-level applications. Discover practical implementation techniques through demonstrations, including the creation of roles and integration with Active Directory groups. Delve into topics such as management studio usage, data exploration, organization nodes, and problem-solving strategies for RLS. Acquire valuable wisdom to enhance your database security practices and effectively manage data access across your organization.
Overview
Syllabus
Introduction
What is Row Level Security
Implementation
Management Studio
Data Exploration
Organization Node
Row Level Security
Refactor
Sales Order Header
Problem Fix
Demo
Creating Roles
Active Directory Groups
Wisdom
Taught by
PASS Data Community Summit
Related Courses
-
AZ-500 Microsoft Azure Security Technologies
-
SQL Server Security Basics - Security
-
Data Security Using Roles, Privileges and Row Level Security - PL/pgSQL Implementation
-
Secure SQL Server Database Design - Tactics and Technology
-
SQL Security for Everybody - Understanding Logins, Users, and Roles
-
SQL Server 2022 - The Hybrid Data Platform
