Google Data Analytics, IBM AI & Meta Marketing — All in One Subscription
Build GenAI Apps from Scratch — UCSB PaCE Certificate Program
Overview
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 essential database security concepts in this 27-minute lesson from an MTA Database course. Learn about security principles, simplified security models, and server-level security measures. Dive into fixed server roles, SQL Server security, and Windows authentication using T-SQL commands. Understand SQL Server user authentication processes, methods for granting database access, fixed database roles, and object permissions. Practice granting object permissions through hands-on examples to reinforce your understanding of database security fundamentals.
Syllabus
Intro
Objectives
Security principles
Simplified security model
Server-level security
Fixed server roles
SQL Server security
Windows authentication - T-SQL commands
SQL Server user authentication
Granting access to a database
Fixed database roles
Object permissions
Granting object permission examples
Taught by
Paul Browning