Chapter 18 – View Functions
"Be the change that you want to see in the world."
- Mahatma Gandhi
Creating a Simple View to Restrict Sensitive Columns
CREATE View Employee_V AS
FROM Employee_Table ;
The purposes of views is to restrict access to certain columns, derive columns or Join Tables, and to restrict access to certain rows (if a WHERE clause is used). This view does not allow the user to see the column salary.
Creating a Simple View to Restrict Rows
CREATE VIEW Employee_View