Database Security and Authorization: Views

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:

  1. 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.
  2. 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)

Leave a Reply

Your email address will not be published. Required fields are marked *