From the course: SQL Server: Security for Developers
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Contained users and their benefits - SQL Server Tutorial
From the course: SQL Server: Security for Developers
Contained users and their benefits
- [Instructor] Contained Users are a feature that got introduced in SQL Server 2012, which was right around the time Microsoft really started promoting Azure SQL Database as something that we could more broadly use. And they're kinda tied back to the history of Azure SQL Database and it's original concept. But contained users are really cool concept in that they separate the database user from the server. So, your user account will travel with that database, whatever server it runs on. That user account will be able to log in to that database, and it's a little bit different in how we handle connection strings and that we're always gonna have to specify a database name, but it gives us better security and a little bit tighter control. So, like I mentioned, if we move a database from one server to another this is a really major benefit of a contained users. So they use all the user's information, whether it's the password hash if it's SQL user, or the active directory information, it's…
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.
Contents
-
-
-
Logins and users3m 39s
-
Azure AD and SQL authentication3m 42s
-
Demo: Create a user in SQL Server4m 36s
-
Roles and privileges overview3m 26s
-
Least privileges principal4m 20s
-
Building custom roles in SQL Server3m 44s
-
Demo: Building custom roles3m 2s
-
Predefined roles in SQL Server2m 57s
-
Roles in Azure SQL Database2m 45s
-
Contained users and their benefits3m 3s
-
Demo: Contained users2m 22s
-
-
-
-