IBM Db2 11.1 Certification Guide

Views with CHECK OPTION

A view is a way of representing data without the need to store and maintain it. A view is not an actual table and requires no storage. It also provides a different way of looking at the data in one or more base tables.

For example, if you want to restrict users from accessing SSN and SALARY information, you can easily do so by creating a view without these columns and limit the user's access to only the view. An example of this is shown as follows:

CREATE TABLE demo.employee ( empid INTEGER, name VARCHAR(30), ssn VARCHAR(11), salary INTEGER ); SELECT * FROM demo.employee; EMPID NAME SSN SALARY ----------- ------------------- ---------------- ----------- 1 Robert, Colin 999-99-9999 90000 2 Milan, Mohan 111-11-1111 80000 ...