From the course: Database Foundations: Database Management
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Views and database security
From the course: Database Foundations: Database Management
Views and database security
- [Instructor] Relational database view objects can play an important role in the security of your data. Instead of giving end users direct access to all of the data contained in a database, you can limit them to just the rows and columns that are relevant to their work. Here's a couple of different ways that you can leverage view objects to help add a layer of security to your valuable information. First, views can restrict access to data in a number of ways, they can expose only the rows and columns that you specify. For instance, a specialized view can be created that pulls only relevant columns from the underlying data table. By granting users permission to access only the view, and not the full table, you can effectively keep them from interacting with information that they shouldn't be able to see or modify. In this regard, views provide a level of security on your database by creating an intermediary filter that operates between the raw data and your database users. Second…
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.