This facility provides a personalized model of database to a particular user. By using this facility, DBA can hide data from user that is not required by the user.
Advantages : The main advantages of views are:
- Simplify the system usage : User can only see the data of its own interest on which he really wants to do This is also helpful in optimization of resources.
- Limits user access of data : User can see only a particular part of If a user cannot see other data then how he can violate the security rules.
A good mixture of authorization and view helps in maintaining a secure server.
Source: Gupta Satinder Bal, Mittal Aditya (2017), Introduction to Basic Database Management System, 2nd Edition-University Science Press (2017)