Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Explore SQL Server security concepts in this 52-minute conference talk from PASS Data Community Summit. Delve into the intricacies of controlling user access within a SQL Server instance, breaking down permissions from the instance level down. Learn to differentiate between server and database principals, understand the functionality of server and database roles, and discover how to leverage custom roles and object-level permissions for optimal access control. Gain practical insights through demonstrations tailored for developers, junior and accidental DBAs, and system administrators seeking to implement effective SQL Server security measures. Unravel the complexities of SQL security options and acquire the knowledge to grant appropriate access to applications and end users.
