Section Access is Denied

[vinay_skpk]

Hi,

I am  applying section access with multiple fields .After reload, the app is displaying as "Access Denied" for the user.

Is there a way to exclude Strictly Prohibit feature in Qlik Sense Section access.

[NadiaB]

Hi @vinay_skpk 

The Strict Exclusion is on by default in Qlik Sense.

Could you provide a sample of your Section Access? 

We also recommend the following documentation:

Managing security with section access

[vinay_skpk]

Hi Nadia,

below is the sample table we are trying to use.  In the below scenario we want A and B to access based on the restriction but C to access all data.  we have 13 regions. by giving * C is getting only APAC as region, India and China as Country.  The data access C is getting is only Union of field values we have given in the script where as he needs all fields available in the Data base to access.  

UserID	Region	Country	City	Product
A	APAC	China	Bejieng	Software
B	APAC	India	Delhi	Services
C	*	*	*	*

What should be specified instead of * to get all fields loaded for C.  Any help will be great.

Regards,

Vinay

[NadiaB]

Hi @vinay_skpk 

Have you had the chance to look into the documentation?

The behavior is working as designed, * will show all listed:

The wildcard, character *, in this row refers only to all values within the section access table. If there are values in the section application that are not available in the REDUCTION field in section access, they will be reduced.

You could either ensure all the values are in the current table or you can create profiles and then assign those profiles to the users:

Section Access;

LOAD * INLINE [
ACCESS, USERID, PROFILE
ADMIN, DOMAIN\ADMINISTRATOR, ALL
USER, DOMAIN\USER1, APAC
USER, DOMAIN\USER2, EMEA
USER, DOMAIN\USER3, ALL
];

LOAD * INLINE [
PROFILE, REGION
APAC, APAC
EMEA, EMEA
LATAM, LATAM
ALL, APAC
ALL, EMEA
ALL, LATAM
];

Section Application;

LOAD * INLINE [
REGION, SALES
APAC, 1000
EMEA, 2000
LATAM, 3000

];

Hope it helps.