Security of and Through Views
Because privileges can also be granted for views, you can provide users with access to only a part of a table or only to information derived or summarized from tables. The following are examples of both features.
Figure. Give DIANE the privilege to read only the names and addresses of noncompetitive players.
Figure. Make sure that user GERARD can look at only the number of players in each town.
All types of table privilege can be granted on views.