Databases Reference
In-Depth Information
Reduction fields
Besides the fields listed in the previous section, we can associate additional fields
with the security fields to reduce the set of data that individual users have access to.
Let's follow this example and see how we can limit the flight type (and associated
flights) that are available to different users:
1.
Open the
Edit Script
dialog and select the
Hidden Script
tab.
2.
Update the inline
Section Access
table so it contains the following
information:
ACCESS
USERID
PASSWORD
%FLIGHTTYPE
ADMIN
ADMIN
ADMIN123
*
USER
DF
DF123
DOMESTIC_FOREIGN
USER
DU
DU123
DOMESTIC_US
USER
IF
IF123
INTERNATIONAL_FOREIGN
3.
Next, place the cursor after the
Section Application
statement.
4.
Go to
Insert | Load Statement | Load Inline
in the menu.
5.
In the
Inline Data Wizard
, select
Tools | Document
data.
6.
In the
Import Document Data Wizard
window, select the field
Flight Type
.
7.
Make sure that
Values to import
is set to
All Values
and click on
OK
.
8.
Add
Flight Type
as a column header, and add a second column header for
%
FLIGHTTYPE
.
9.
Fill the table so it looks like the following table:
%FLIGHTTYPE
Flight Type
DOMESTIC_FOREIGN
Domestic, Foreign Carriers
DOMESTIC_US
Domestic, US Carriers Only
INTERNATIONAL_FOREIGN
International, Foreign Carriers
INTERNATIONAL_US
International, US Carriers Only
10. Click on
OK
to close the
Inline Data Wizard
dialog.
The resulting script should look like this:
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, %FLIGHTTYPE
ADMIN, ADMIN, ADMIN123, *
USER, DF, DF123, DOMESTIC_FOREIGN