topic Re: Section Access function not working for Admin profiles in QlikView

Section Access function not working for Admin profiles

Wed, 05 Mar 2014 17:40:37 GMT

Hello! I am working with a simple implementation of the Section Access functionality, but once I reload the data, the functionality appears to be removed, only allowing a user defined to see everything (*) to see NONCONFIDENTIAL data. My goal is to allow some users to see only data flagged as NONCONFIDENTIAL and other users to see everything.

I have also turned on the Settings --> Document Properties --> Opening --> Initial Data Reduction Based on Section Access

I am using an ADMIN access profile to test this, but my expectation is that the Section Access rules should apply to all users. Is this correct?

Here is the script code I am using:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, INCLUDED

ADMIN, SA\abrxyz, *

ADMIN, SA\cvrxyz, NONCONFIDENTIAL

USER, QV\JLxxxx, *

USER, QV\SBxxxx, NONCONFIDENTIAL

];

Section Application;

Re: Section Access function not working for Admin profiles

Wed, 05 Mar 2014 17:55:12 GMT

yes it will apply to admin too

Re: Section Access function not working for Admin profiles

Colin-Albert — Wed, 05 Mar 2014 18:02:26 GMT

If the field INCLUDED has other values apart from NONCONFIDENTIAL then these must be added to the section access list.

In section access "*" does not mean all values, it means all listed values.

Try this - the DUMMY values will allow * to see NONCONFIDENTIAL, CONFIDENTIAL and SECRET values.

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, INCLUDED

ADMIN, SA\abrxyz, *

ADMIN, SA\cvrxyz, NONCONFIDENTIAL

DUMMY, DUMMY, CONFIDENTIAL

DUMMY, DUMMY, SECRET

USER, QV\JLxxxx, *

USER, QV\SBxxxx, NONCONFIDENTIAL

];

Section Application;

Re: Section Access function not working for Admin profiles

Wed, 05 Mar 2014 18:05:04 GMT

Thanks very much for your reply! I can't seem to figure out why then if I set my profile to have full access (*) it still filters automatically on the NONCONFIDENTIAL data. Is there another configuration step I am missing?

Re: Section Access function not working for Admin profiles

Wed, 05 Mar 2014 18:17:44 GMT

As Colin said instead of *, add all the distinct values

Re: Section Access function not working for Admin profiles

Wed, 05 Mar 2014 18:17:49 GMT

Outstanding!! That was it! Thanks very much for your assistance!