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

image

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

image

CREATE VIEW Employee_View

AS

SELECT ...

Get Actian Matrix (Formely ParAccel) - Architecture and SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.