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

Contained users and their benefits - SQL Server Tutorial

From the course: SQL Server: Security for Developers

Start my 1-month free trial

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…

Contents