From the course: Designing Database Solutions for SQL Server 2016
Join today to access over 25,300 courses taught by industry experts.
Introduction to SQL Server security - SQL Server Tutorial
From the course: Designing Database Solutions for SQL Server 2016
Introduction to SQL Server security
- [Instructor] It often feels like I hear about another major data breach every day. Whether it's user accounts getting compromised or credit card numbers being stolen, these types of threats can strike anyone at any time. As they say, the best defense is a strong offense. That's why SQL Server includes a wide variety of techniques that can help secure your valuable information. As a design for a database project progresses, it would be wise to take a hard look at security protocols early and often. Security within SQL Server instances work at multiple levels, and each level has a series of permissions that must be granted in order for users to traverse further into the system. This hierarchy spans from the server instance to the database, to the objects within the database. Together, all of these objects are called securables. Each securable object has a collection of permissions that can be granted or withheld.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.