Databases Reference
In-Depth Information
Figure 8-5.
A table defined to hold usernames and passwords
The developer probably used the wizard to create an account maintenance screen on the
MY USERS
table (Page 2 in Figure 8-5). There were a few changes made: the password field was changed from Text
Field to Password and there was a computation to set the pages user_id item to the user_id of the
logged-in user. The computation set
P2 USER ID
with the following
select
statement:
select user id
from my users
where username = :APP USER
The builder page would have looked like Figure 8-6, with the new computation highlighted.
Figure 8-6.
The APEX Builder for a form on MY_USERS
To be fair, there were certainly other changes, but this provides enough to work with. A key aspect of
this was that the application had been built in a version of APEX that had the Hidden item type, but not
