PPT Slide
If the data being changed will not be
selected by the view, then the view will
not let the user make the data change.
The following view will now guarantee
that any user who tries to insert data into
EMPLOYEE_VIEW for an employee other
than EMPID# 59495 will not be able
CREATE VIEW employee_view AS (SELECT empid,
salary FROM employee WHERE empid = 59495) WITH CHECK OPTION;