From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Introduction to SQL Server security

Introduction to SQL Server security - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

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. Permissions at the server level include adding and altering login…

Contents