From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Create loginless and contained users - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Create loginless and contained users
- [Instructor] When it comes time to test the security of your system, it can be difficult to properly assess all of the permissions that have been assigned to each user role and their affect across the objects that make up a complex database. User accounts typically have to exist at the server level first, before they can be assigned permission to the individual databases. When the server is set to use Windows Authentication, user accounts must exist at the operating system level. This makes it difficult to impersonate different users in order to get a look at how they would see the database. SQL Server also supports mixed mode or SQL Server Authentication, which allows user accounts to be created directly on the server itself. We took advantage of this in the last movie to more easily create a fake user account for testing purposes. There is another way to create users for testing purposes, though, and this one is…
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.