A view provides an alternate way of looking at the data in one or more tables. It is a dynamic window on tables.
Views allow multiple users to see different presentations of the same data. For example, several users may be accessing a table of data about employees. A manager sees data about his or her employees but not employees in another department. A recruitment officer sees the hiredates of all employees, but not their salaries, while a financial officer sees the salaries, but not the hiredates. Each of these users operates with a view derived from the real table. Each view appears to be a table and has its own name.
An advantage of using views is that you can use them to control access to sensitive data. So, different people can have access to different columns or rows of the data.