Section Access

[#1]

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.

[#2]

It says the script execution failed and then when i try to run my file asks password....but still when i give the admin password no data visibilty at all.

Should i attach my qvd file ????in order to have a look???

[#3]

Yes i am sure

[#4]

It says the script execution failed and then when i try to run my file asks password....but still when i give the admin password no data visibilty at all.

Should i attach my qvd file ????in order to have a look???

[IAMDV]

Hi,

Please attach your QVW file and one of us can look at the script. Meanwhile, can you make sure that you have used UPPER() function on VALIDATORUNIT field. Not just in the Section Access script but the actual field reduction should be in Upper Case. That could be the reason you are seeing NULL values.

However, please share the QVW & QVD files and I'm sure we can easily sort out for you.

Good luck!

Cheers,

DV

www.QlikShare.com

[#6]

As i mentioned before i used the hiddent script :

Section Access;

LOAD * INLINE [

    ACCESS,                       USERID,                         PASSWORD,                    VALIDATORUNIT

    ADMIN,                       nkavroulakis,   george45,                     NV200

    USER,                       TestUser,                       1234,                               BV50

];

To give diffrent access to users but it does not seem to work i get blank file.Can you check what is the potential error...

[#7]

Does anyone has any ideas..anything i tryied does not seem to work...:(

[Peter_Cammaert · Accepted solution]

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

[Anonymous]

HI Nikolaos,

don't know if you've already fixed but the really "misterious & magic trick" for me is  point 2 of Henric Cronström suggestion : all fields must be UPPERCASE.

You can setup anything in the correct way but without this little hint .. it won't work :O)

Best regards,

Fabrizio