Databases Reference
In-Depth Information
By opening a second copy of the QlikView software and testing our file in that, we've
significantly reduced the risk of getting locked out of our document. If anything is
wrong, we can just revert back to the document that we did not close after saving
and make the required changes to section access before repeating the process to try
again. Using this approach is highly recommended.
Association works in section access too
So far we have been using a single table to store our section access
data. However, we can use multiple, associated tables as well.
For example, when we want to
OMIT
multiple fields for a single user,
we need to add each field on a separate line. We can do this within
the single table that we've been using so far. However, a better
alternative is to remove the
OMIT
field from the first table and create
a second, associated table that contains the
USERID
and
OMIT
fields.
Now that we've seen how we can limit who has access to our document, and what
they can see, we will now look at how we can restrict what users can do within the
document in the next section.
Document-level security
User privileges can be set on two levels within QlikView, at the document level and
at the level of individual sheets. We can open the document-level user privileges by
pressing
Ctrl
+
Alt
+
D
to open the
Document Properties
dialog and selecting the
Security
tab. This tab is shown in the following screenshot:
