SQL Security for Everybody: Understanding Logins, Users, and Roles - Josh Smith

There are a lot of options for controlling what can be done to control user access inside a SQL Server instance, and that granularity can be confusing to everyone (including database administrators). In this session we’ll break down permissions from the instance level down, to understand the difference between server and database principals, how server and database roles work, and how to use custom roles and object-level permissions to grant just the right amount of access to our applications and end users. Filled with practical demonstrations this session is geared for developers, junior and accidental DBAs, and system administrators looking to understand how best to implement SQL Server security.
Watch the session recording from PASS Summit 2020. For updates on the future of PASS, SQLSaturdays and PASS Summit opt in here: www.red-gate.com/pass