With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, tutorials, and more.

Chapter 18 – View Functions

Creating a Simple View to Restrict Sensitive Columns

CREATE View Employee_V AS

SELECTEmployee_No

,First_Name

,Last_Name

,Dept_No

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

AS

SELECT ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, interactive tutorials, and more.