Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

Security

Views provide security by hiding sensitive or irrelevant parts of the database. If permissions are set up properly, the accountant can find out how big an author's check should be, but can't look at the underlying figures or compare his or her own paycheck to a coworker's. You can restrict the accountant's access in the database to just those views that are relevant to accounting. Using views as a security mechanism is discussed in more detail in Chapter 10.