AP: Building a Secure Access and SQL Server Application, by Anders Ebro HD

Anders Ebro takes us step-by-step through setting up Security for SQL Server with Windows Authentication. Topics include: Logins & User Accounts Granting Permissions to Users Add Users to Default Database Roles Create Custom Roles Create Logins for Active Directory Groups Add Users to Custom Roles Add AD Groups to Roles Granting Permissions to Roles Execute AS USER Grant RIGHTS on OBJECTS to PRINCIPAL PRINCIPAL: Windows Group or Custom Role, not users Column Level Security Row Level Security WITH CHECK OPTION RLS by Security Policy (SQL Server 2016 or newer) Block PREDICATE for Security Policy Admin Override Featuring Demos of each feature and much more in Access