Databases Reference
In-Depth Information
3.
Set the value of the new
OMIT
field to null for all existing users, by adding a
comma (
,
) at the end of each
ADMIN
and
USER
line.
4.
Add a new user at the bottom of the list by entering the following script:
USER, NOCARRIER, NOCARRIER123, *, Carrier Name.
5.
Go to
File | Save Entire Document
to save the document.
6.
Click on the
Reload
button to reload the script.
The resulting script should look like this:
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, %FLIGHTTYPE, OMIT
ADMIN, ADMIN, ADMIN123, *,
ADMIN, ADMIN, ADMIN123, INTERNATIONAL_US,
USER, DF, DF123, DOMESTIC_FOREIGN,
USER, DU, DU123, DOMESTIC_US,
USER, IF, IF123, INTERNATIONAL_FOREIGN,
USER, NOCARRIER, NOCARRIER123, *, Carrier Name
];
We've created a new user,
NOCARRIER
, whose password is
NOCARRIER123
. This user
has access to all flight types, but cannot see the
Carrier Name
field.
Notice that the values in the OMIT column do not need to be in upper
case, instead they need to match the exact case of the field names that you
want to omit.
We'll test if this works according to plan, but this time we will use another method.
Let's follow these steps:
1.
Keep your current QlikView application (the program) and document open.
2.
Start a second copy of QlikView from the start menu or your quick
launch shortcut.
3.
If you get an
Auto Recover Files Found
warning, click on
Close
to close it.
4.
Go to
File | Open
and select the
Airline Operations SA.qvw
file.
5.
When prompted for a user id and password, enter
NOCARRIER
and
NOCARRIER123
respectively.
If everything went well, we should see that the
Carrier Name
listbox is empty, and
that the field is marked as
(unavailable)
.