Database Reference
In-Depth Information
19. Locate and open the file
ch9_report_p500.txt
, and copy its con-
tents into the
SQL
region, replacing everything that is there. Click
Ap-
ply Changes
.
20. Run
Page 500
, and notice that the chart only reflects the status of
either unassigned tickets or tickets that are assigned the current user.
This is a huge leap forward in data security, but you're not quite finished. You may
have noticed that if you edit one of the records on page 210, you can use the Next (>)
and Previous (<) buttons in the upper-right corner to see records that belong to other
users. Thus, you need to plug this security hole as well:
21. Edit
Page 210
of the application.
22. The location of the process
Get Next or Previous Primary Key
Value
is shown in
Figure 9-37
. Edit the process by double-clicking its
name.
Figure 9-37.
The location of the Get Next or Previous Primary Key Value process