From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Manage database users

Manage database users - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial

Manage database users

- [Instructor] Security in SQL Server is multi-tiered. You can configure security at the server level, by using logins and server roles. However, you can also configure security at the database level. Security at the server level and the database level will work in concert to ensure that you can specify granular security for your databases while maintaining server level security as well. Security at the database level consists of users and roles. In this video, we're going to focus on users. If we expand the users folder, we can see the default users that get created for every database. If we want to add a new database, right-clicking users and choosing new user gives us that dialogue box. We can choose the user type from that drop-down, and in this case there are two options for SQL users, one with and one without a login. The more advanced ones where users are mapped to a certificate or asymmetric key, and of course a Windows users for Windows authentication. We're going to stick…

Contents