From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Implement schema security - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Implement schema security
- [Instructor] We've seen how granting permissions is much more efficient when applied to the user role as a sort of permission container, and then users are assigned to roles to receive those permissions. This makes maintaining the security of the database much more manageable. We could apply the same rationale by assigning permissions at the schema level in the database, rather than at the object level. Doing so will automatically grant the same permissions to every object in the schema without explicitly having to call out each and every one. Let's take a look at this by using the wideworld importer's database. I'll go ahead and execute the line using use wideworld importers then go. Next I'm going to move this down a little bit on the screen so you'll see our script a little bit clearer. Then, I want to take a look at some of the schemas that are already present in this database. I'll expand the database's folder and…
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.