Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Section Access

Hi there Qlikview community,

I am having some problems on using section access in order to give certain views to different users.

my hidden script table is shown above

Section Access;

LOAD * INLINE [

    ACCESS,                       USERID,                         PASSWORD,                    VALIDATORUNIT

    nkavroulakis,   nkavroulakis,   george55, BM200

    TestUser,             TestUser,                       1234,                               BV50

];

All my records in VALIDATORUNIT are uppercase but still not loading any data at all.....
Any ideas????

Thank you in advance.

1 Solution

Accepted Solutions

Re: Section Access

Thanks for this example.

I did an export of your data (a single table called Validators_Boundaries) to a file called VB.QVD. Then I made a new model with some listboxes, and a script that does two things:

1. Load the SA INLINE table (missing from your example qvw) with the code from your comment immediately above mine.

2. Perform a LOAD of VB.QVD

Enabled both "Initial Data Reduction Based on Section Access" and "Strict Exclusion".

This model works without a problem. See the attachment, this one has a disabled SA. To test it yourself, make a copy of this file (like "TestSA Secured.qvw") enter the script and remove the comment markers from the first line. Reload, save the qvw, restart QV and load the new file. Use the above credentials (in UPPER CASE) to enter the newly secured model.

You didn't forget to put Section Application; somewhere in your original script by any chance?

Best,

Peter

17 Replies

Re: Section Access

The ACCESS column should have the value ADMIN or USER.

HIC

Re: Section Access

Data in column "ACCESS" must be one of USER or ADMIN. Other values will cause those rows to be ignored.

Best,

Peter

Not applicable

Re: Section Access

Still not working although altered my script like this:

Section Access;

LOAD * INLINE [

    ACCESS,                       USERID,                         PASSWORD,                    VALIDATORUNIT

    ADMIN,   nkavroulakis,             kavros14,

    USER,             TestUser,                       1234,                               BV50

];

Re: Section Access

Remember, Section access tables won't show up in your document. They will grant/refuse access, reduce data if needed, manage initial selections and so on. But you will never see a table containing usernames and passwords.

"...but still not loading any data at all..." What exactly is happening in your document? Is everything reduced away?

Best,

Peter

Re: Section Access

Do you get all data or no data?

Make sure that

  1. Document properties -> Opening -> Initial data reduction etc. is set
  2. All field names and all field values in Section Access are upper case

HIC

Not applicable

Re: Section Access

Yes it is propable reduces all information away.....and leaves it blank

Re: Section Access

Are you sure you have fields with identical names in both Section Access and outside to link your SA to the rest of the data?

See also Henric's remarks about case below.

Peter

Re: Section Access

A good debugging method is to just comment out the "Section Access" statement. Then you will get the section access table as a normal table and you can often see what goes wrong.

HIC

Not applicable

Re: Section Access

Yes its alla set in document properties still no results

Community Browser