Databases Reference
In-Depth Information
Locate and open the file
ch9_report_p500.txt
, and copy its contents into the
SQL
region,
replacing everything that is there. Click
Apply Changes
.
19.
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
23.
Change the value of
Table Name
to
TICKETS_SECURE_V
, as shown in Figure
9-38
. Click
Apply Changes
.