SQL Server Security Primer - Least Privilege Access and Protecting Data

We will review the security mistakes I have frequently encountered during 10+ years of SQL Server consulting, understand why they are wrong, and see multiple demos of how to do it right.

We explore how to determine existing user permissions, how to provide those permissions through database roles, how to allow custom objects in a production database through a new schema, and how to assign permissions at the stored procedure level rather than to the users calling it. Protect your database by granting least permissions the most effective way

Agenda
6:00 pm - Welcome to TVUG, user group announcements
6:05 pm - Session start
7:00 pm - Session wrap-up, open Q&A

This session is part of the .NET Virtual User Group (https://www.meetup.com/dotnet-virtual-user-group) series, where you can join and find more virtual user groups happening around the world.