The user attempts change the retail price the book shortest poems

Keep in mind that the query defining the INVENTORY view didn’t filter rows with a WHERE clause, so all book rows are accessible through the view. However, row filtering is a popular reason for creating views. For example, JustLee Books might want to limit regional managers’ access to customer data based on their region. To limit their access to rows with a specific region value, you can use a WHERE clause in the view. Figure 13-5 shows creating this view for the Northeast region.

Chapter 13

		479
FIGURE 13-6	Failed updates on the INVENTORY view