Database Reference
In-Depth Information
Figure 12-3.
Application date format
•
Authentication
: Select Custom, and replace
- BUILTIN -
with the
statement
return f_login
in the
Authentication Function
field, as
shown in
Figure 12-4
.
Leave all the other inputs at their default values.
(
f_login
refers to the function you created in the “Setup” section of
this chapter.)
Figure 12-4.
Custom authentication
•
SQL and PL/SQL
: Select
Yes
for
Allow SQL and PL/SQL
. This lets
you reference tables and views in the underlying schema. After you se-
lect Yes, an Add Object button appears. Click
Add Object
, and enter
TUSERS
for
Object Name
, as shown in
Figure 12-5
.
This will allow
users to quickly select the
TUSERS
table when creating reports. Click
the
Create
button, which brings you back to the application properties
page.
